can one field;s data define the options of another field in the same table?

[Greg_Forse]

total beginner here.



I was wondering if it was possible to have a field which defines which subset data belongs in and then have a second field in the same table which was more nuanced based on the first answer?

For example I have field 1 and field 2. Field 1 is 'types of food' and I want to select 'pizza' as a designed option in the lookup section. Once I select 'pizza' in field 1 is it possible to have field 2 only display 'toppings, crust, base etc' without having to have a massive list of all possible nuances for field 1?

Basically can my answer to 1 narrow down my options for 2 without needing any more action on the users part?

If not is there another strategy that I am unaware of?

Any help appreciated.

Cheers

[ranman256]

if you are using a combo box,
user picks PIZZA for fld1
then fld2 can be filtered to show: pizza hut, papa johns, etc.
or : pepperoni , crust, etc.
but you only get 1 value for Fld2.

if you DO want multiple values ,then you want a parent/child table,
the subTable would hold infinite values: 'toppings, crust, base etc'

[pbaldy]

Sounds like:

http://www.baldyweb.com/CascadingCombo.htm