Drop Down Value List In Field To Define Another Value List In A Field

[Nice-biscuit]

Apologies up front for the newb question, but I am having difficulty following the Filemaker Help on this particular topic and I would appreciate some help

My dilema is I need to create a field that behaves and reacts to whatever is in another field using drop down value lists.

field 'TYPE' is a drop down list containing a value list 'Furniture, Household, Lighting'. Dependent on the value I chose in 'TYPE',I want it to activate a selected value list in my second field 'SUB TYPE'. So if I select ' furniture ' from my drop down list in 'TYPE', the 'SUB TYPE' field will display a selected value list connected to 'furniture' alone. eg chair, sofa, table. If I chose 'Household' in the 'TYPE' field, I would like another list to appear in 'SUB TYPE' connected to 'Household' only. eg kitchen equipment, rugs,edit...

How do I go about this? Any help is much appreciated

[Keith LaMarre]

test.fp7.zip

To do this - you need to make a relatoipnship between your "Products" table and your "Quote/Selection" table... (or if its just one table then it would be a self relationship.

The first value list would have your Type fields - Furniture, Household, Lighting - and the second value list will be based on the relationship to Type...

I am enclosing a test file to show you how this works.

[Nice-biscuit]

Thank you Keith, I will have a look at this