Database Designing

[Tammy]

I want to create a table/form

here is how it would work.

You select one value from one table, that would give you a list of values
distinct to that value to select your next value.

For example

If I were to select:

Ice Cream from table 1 in field one - I would be given a new set of choices
like (strawberry, chocolate, vanilla) from table 2 to enter into the field
number 2.

But if I were to select Cheese from table one - then my set of choices in
field 2 would be (parmesan, cheddar, mozza).

Or if I were to select Beverages from Table one - then my set of choices in
field 2 would be (milk, yogurt drink, etc.)

I am sure you get a good idea of what I want. How do I design my
relationships, etc.

Thanks.

 

[KARL DEWEY]

Table 1-
Code Description
1 Ice Cream
2 Cheese

Table 2-
Code Item Description
1 1 Strawberry
1 2 Vanilla
1 3 Chocolate
2 1 Cheddar
2 2 Parmesan