1 Reply Latest reply on Nov 15, 2010 10:45 AM by philmodjunk

    using dropdown lists with related tables

    toddphilipps

      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.

        • 1. Re: using dropdown lists with related tables
          philmodjunk

          Keep the field based on Parts::Product_ID.

          Make the drop down's value list a two column value list. Make column 1 Products::Product_ID and column 2 Products::Product_Name.

          Then, when you select a product, you can use the name to select the correct one, but the drop down enters the ID. Parts::Part_Name can be set up with a looked up value setting to copy the Products::Product_Name into it each time you select a Product ID.