using dropdown lists with related tables
I'm new to FileMaker Pro 8.5 so bare with me....
I have two tables:
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.