I am sure there are some easy solutions to this problem. I have three tables clients list, campaigns list, and campaign request form list. I want to lookup records. The problem is that my column type is a reference list. Few days ago, i was stuck with similar problem but found a solution to add contain formula in the lookuprecord formula. However that was mathematical problem. Now I want to show all the client names that are associated with a client request id. here is the formula; $Requisition_Form.Client_Name.Clients
The formula works as soon as I change the type to reference collumn instead of a reference list. Any idea how to do this?