Can you link a table with the relation being a calculated field for one of the tables? I am trying to have a field for every sales rep on an AR Invoice which has their name. The field on the invoice header is a list of reps separated by a ~. I was able to break out the sales rep ID, but not I can’t link those up to the SalesRep table to grab the name since they are all calculated fields?
Any way to do this?