2 Replies Latest reply on Mar 27, 2010 8:51 AM by GMoors

    Using value lists



      Using value lists


      computer: Apple Macbook Pro

      os: Snow Leopard

      Filemaker: Filemaker 11 Pro

      database: on my machine (no internet, no sharing)


      I've two tables: hardware and category.

      The category-table has two fields: cat_ID (number) and cat_Name and contains values like laptop, computer, beamer, LCD, printer, ...


      My hardware-table contains a field hw_cat_ID which must contain the ID of a category (type: number). This field is related to cat_ID of the category-table.

      On my form I've placed a dropdown-list that is build like the manual says (File --> Manage --> Value lists...).


      This all works great but...


      On the (hardware-)form I only want to see the cat_Name in the dropdownlist and store the (cat_)ID of the selected categegory in the hardware-table. Can someone tell me how this has to be done?


        • 1. Re: Using value lists

          When you specify the field while editing the value list, there are two additional checkboxes:-

          • "Also display values from second field"  -- Check this and select the table and field you want to show on the drop-down list

          • "Show values only from the second field" -- Check this.


          Phil's tutorial on drop-down lists may be of interest to you.

          • 2. Re: Using value lists

            Thanx Jade


            I had the settings set, like you mentioned.

            I also changed the component from Drop-down list to a Pop-up menu and now it functions like I wanted.


            Also thanx for the tutorial.