@Chase, record.load puts you in edit mode. You'll either need to have your deployment set to execute as admin OR do some fancy search.lookupfields OR save the troublesome fields to the record in a way that you can acess them via columns or column joins.