AnsweredAssumed Answered

Question: How to return multiple lookup values for a field that contains multiple values?

Question asked by DeShawnJackson on Feb 25, 2011
Latest reply on Feb 25, 2011 by DeShawnJackson

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.

Outcomes