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

    Using value lists

    GMoors

      Title

      Using value lists

      Post

      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
          Jade

          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
            GMoors

            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.