5 Replies Latest reply on Nov 15, 2012 1:05 PM by AlexanderKolbe

    Values from separate Table in Drop Down List

    AlexanderKolbe

      Title

      Values from separate Table in Drop Down List

      Post

           Sorry for such a dummy question but I'm new to FileMaker.

           I have a table called PRODUCTS that contains several products. The other table, CATEGORY, contains the categories and a number for each separate category.

           The PRODUCTS fields are 

           ProductName
      Category (This should be a drop-down from my categories list)
      CatNumber (this should be added automatically from the relevant category)
           Price
           ProdID
           Color
           et cetera

            

           The CATEGORY table contains only:
           Category
           CatNumber
           ID

           What I want to achieve is when someone adds a record to the products list a popup list should appear where you can chose "Tiles", "Bricks", "Hardwood Floor" for example. I managed to get that. But I also want FM to automatically add the CatNumber when the category is chosen. It should appear like this:

           [Tiles] 09-30-00
           [Natural Stone] 09-50-00

           I managed to create the drop-down list with values from CATEGORY but the number field shows all the numbers available but not the one that is specific for the chosen material.

           Does somebody understand my problem?