troubleshooting Question

Creating a lookup field from multiple selections of a related field.

Avatar of jarrodprice
jarrodprice asked on
FileMaker Pro
15 Comments1 Solution572 ViewsLast Modified:
In table #1 there are 2 fields "name" and "code".  In table #2 there are the same 2 fields.  The name field in table 2 is a radio button value list of the name fields from table #1.  The code field in table#2 is a lookup of the code field from table #1.

For each name field in table#1, (red, blue, green, etc) there is a corresponding number in the code field.  In table #2, I can select more then one name field at once (red and green..etc).  If in table#1 red is "1" green is "2", the lookup result for the code field of table#2 should be "12", thus combining the codes from the selected name fields in table #1.

I am not sure how to achieve this.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 15 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 15 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros