Dynamic value list

[niessen]

Hello- I am new both to this forum and to FMP. I am having problems limiting some value list dropdowns depending on a selection made in a different field, but same layout. I am hoping someone will be able to help me out. I am making a database to keep track of orthopaedic surgeries and I would like to have the dropdown list of component sizes to be dependent on the brand of implant used. I have a separate calculation field (using ValueListItems) which shows the correct sizes for each brand used. Then I have a field with value lists from this calculation field that allows the user to select the size. The problem is, all the values show from the different brands, although the calculation field only shows the relevant sizes. Any advice? I hope I have explained the problem clearly. Thanks in advance.

[-Queue-]

See here for a good dynamic value list example.

[niessen]

Thanks for your help. I think this will work. We have between 3 and 5 components with sizing and names dependent on implant brand. Should I just make tables for each component sizing and name then relate them to the input table?

[-Queue-]

No, just use one table that has brand and size fields, and create one record for each combination. Then create a relationship from your main table to brand in the new table and base your second value list on the new table's size field, defining it to 'include only related values starting from' the main table.

[niessen]

I finally got around to implementing this method and it works beautifully. Thanks again for the help.