AnsweredAssumed Answered

Populating a Dropdown List and Capturing the Field Value

Question asked by Tex1 on Jan 12, 2010
Latest reply on Jan 12, 2010 by philmodjunk

Title

Populating a Dropdown List and Capturing the Field Value

Post

Hello,

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?

Outcomes