9 Replies Latest reply on Jul 4, 2012 4:16 PM by GuyStevens

    Dropdown list to populate other fields based on selection...HELP!

    heath

      Title

      Dropdown list to populate other fields based on selection...HELP!

      Post

      Hello and thank you in advance-

      I have a database in which there is a table for customer and a table for workorders.  When the client starts a new workorder in the workorder table, they go to a dropdown list that is based on the contents of the customer table "name" field.  When they select the customers name from the dropdown I would also like it to populate the customers address and possibly phone number in the corresponding fields on the workorder table.  Do I need a script to do this.  How do I tell FMP that I want the address matching the name selected from the dropdown?  i.e. all of the information from the customer record residing in the customer table...

      Hope this makes sense...