Question: How to return multiple lookup values for a field that contains multiple values?
TableA::FieldA >>> stores multiple ID values separated by a return
TableB::FieldA >>> stores unique IDs (IDs that can be chosen to store in TableA::FieldA)
TableB::FieldB >>> stores text that needs to be returned in a lookup
Relationship >>> TableA::FieldA = TableB::FieldA
If user selects multiple values in Table::FieldA, what would be the calculation to lookup and display the relating values in TableB::FieldB???
When I create a lookup field in TableA::FieldLookup >>> Lookup ( TableB::FieldB ), it only returns the lookup value that matches the first value in TableA::FieldA.