1 Reply Latest reply on Jan 12, 2010 4:53 PM by philmodjunk

    Populating a Dropdown List and Capturing the Field Value

    Tex1

      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?