I have a form with two fields. In the 1st field the user can select from six
options in a lookup table. However each of the six options has between three
and twenty-three sub headings. I am trying to get the appropriate set of
subheadings linked to the 2nd field once the 1st field is sellected.

Example: once the user selects COW for the first field, they can choose
from MILK, BUTTER, CHEESE, or MEAT for field 2. If they choose PIG then
field 2 gives them a whole new set of options.

You need to have two tables with a one to many relationship

The Table with the Animals (Cow for example) should have a Auto Number
Primary Key field(I would use the field name pkAnimal)
and a text field named Animal
that would relate to the Foreign Key (field - fkAnimal) in the other Table
named Product(Milk etc.)

You could then build your form using a main form(Animal) and a continus sub
form with the relationships between the tables.


--
Andy Austin

"JustCurious" <gsbooker1 (AT) earthlink (DOT) net> wrote

I have a form with two fields. In the 1st field the user can select from six
options in a lookup table. However each of the six options has between three
and twenty-three sub headings. I am trying to get the appropriate set of
subheadings linked to the 2nd field once the 1st field is sellected.

Example: once the user selects COW for the first field, they can choose
from MILK, BUTTER, CHEESE, or MEAT for field 2. If they choose PIG then
field 2 gives them a whole new set of options.