Hi there,

Please can you advise? I have a database with the fields "Category" and "Item". There are multiple categories. Each Item record is different, but some will have the same category next to them. I have a drop down list that lets me choose a category, but i would like to be able to choose in a second drop down an item that belongs in the category chosen in the first drop down.

Does this make sense?

Hope someone can help!

Thanks,

Mike

See if this helps:
http://help.filemaker.com/app/answers/detail/a_id/5833/kw/conditional value list

Brilliant, thank you very much for the link. Worked a dream. However I have another query. I have added the field ItemRef, and now i need that to display the associated value, based on what is chosen in the Item drop down box.

Hope it makes sense.

Thanks,

Mike

10 minutes ago, MikeREvans said:

Hope it makes sense.

 I am afraid not.

Please see attached examples. I attach sample of the table, and a sample of the layout. In the layout the "Category" chosen does now create a relevant value list for the "Item" field. If you notice below the "Item" box is a "ItemRef" box, I would like that to show the "ItemRef" for the item, "ItemRef" is also a unique number.

 

Mike

I suspect I need a script to run on Exit of "Item" box to refresh the ItemRef cell.

Or make ItemRef lookup the value from the subtable as an auto enter option, or simply show the now related firld from the subtable - Category::ItemRef

Thank you :-)