AnsweredAssumed Answered

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

Question asked by heath on Jul 4, 2012
Latest reply on Jul 4, 2012 by GuyStevens

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...

 

 

Outcomes