1 Reply Latest reply on Feb 25, 2011 1:22 AM by DeShawnJackson

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

    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.