I am trying to modify a database that has entries in
several tables that have options from zlookup tables.
What I need to do is modify the design so that the
options in the second dropdown list change as the entry
from the first dropdown changes.

For example, if the first option selected is "animal" I
want the next drop down to give options such
as "cat", "dog", "horse".

If the first option is "plant" instead of "animal", I
want the next dropdown to have "tree", "algae", "bush".
TIA