Populating a Dropdown List and Capturing the Field Value
Please I need some help. I'm pretty new to FileMaker. But I'm trying to achieve something which I think should be pretty simple.
I have 3 tables.. CONTRACTS, CUSTOMERS and CUSTOMER_CONTACTS
The relationship between the table are as follows.
A customer can have many contracts (one-many)
a customer can also have many contacts (one-many)
On the Contracts Form Layout when I select a Customer (from a dropdown), I'd like to populate another dropdown with all of the selected customers' CONTACTS.
Please, how do I go about doing this?