This content has been marked as final. Show 1 reply
I don't know your level of experience with Filemaker, but it sounds like maybe you need 2 tables:
- Table with one record for each Supplier, with a second field listing all of the products that supplier provides.
- Table for your order form (if that's where you're trying to click on the supplier name), with a relationship to Table #1 by Supplier Name. Then when you select a Supplier, you should have a portal or a relationship field that grabs all of the products they provide.
Does that help? Or am I not understanding how you want the functionality to work?