AnsweredAssumed Answered

using dropdown lists with related tables

Question asked by toddphilipps on Nov 12, 2010
Latest reply on Nov 15, 2010 by philmodjunk

Title

using dropdown lists with related tables

Post

Hi all,

I'm new to FileMaker Pro 8.5 so bare with me....

I have two tables: 

Products:
Product_ID
Product_Name

Parts:
Part_ID
Product_ID
Part_Name

In my Parts layout for data entry, I want to have a drop down list containing all Products:Product_Name values and Part_Name text field.

When saving the data, I want the Parts:Product_ID = Products.Product_ID related to the Product_Name I selected.

I can create the dropdown list but the field is associated with the Parts:Product_ID and it saves the Product_Name in the Parts:Product_ID field because of that association.

Any ideas?

Thanks,

Todd.

Outcomes