Drop down list blues!

[MikeREvans]

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

[comment]

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

[MikeREvans]

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

[comment]

10 minutes ago, MikeREvans said:

Hope it makes sense.

 I am afraid not.

[MikeREvans]

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

[MikeREvans]

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

[webko]

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

[MikeREvans]

Thank you :-)