AnsweredAssumed Answered

Values from separate Table in Drop Down List

Question asked by AlexanderKolbe on Nov 15, 2012
Latest reply on Nov 15, 2012 by 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?

Outcomes