Title
Question: How to return multiple lookup values for a field that contains multiple values?
Post
Setup:
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
Problem:
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.
Found my answer described in a similar situation from the post below:
My solution:
Set TableA::FieldLookup >>> List ( TableB::FieldB )
Multiple Records into One Field