Greetings from the beautiful Sierra Nevadas and High Desert of northwest Nevada.
I'm getting stuck creating two cascading dropdown menus for classifying new inventory items.
There are separate tables for
Inventory,
Category 1, and
Category 2.
The
Category 1 Table is simple, and contains a dozen options.
The
Category 2 Table creates a relationship between the choice of
Category 1 and the options available for
Category 2.
(This is like having Category 1 be US State Names, and Category 2 being specific cities in each state.)
The
Inventory Table includes fields for
Category 1,
Category 2, and additional fields whose values are 1:1 dependent on
Category 2. There may be from
one to
dozens of
Category 2 values dependent on
Category 1.
Category 1 has a
many-to-one relationship with
Inventory (each Inventory item can only have one Category 1 value).
Category 2 also has a
many-to-one relationship with
Inventory (each Inventory item can only have one Category 2 value).Category 2 has a
many-to-one relationship with
Category 1 (each Category 1 has a unique subset of Category 2 values associated with it).
Also, when a
Category 2 value is selected it also specifies the value that will be assigned to two (possibly more) other fields associated with that item in the
Inventory Table. This could be like the names of the mayor, police chief, and fire chief for that city.
When a new
Inventory item is entered,
the user must first choose a
Category 1 value from a dropdown,
then select a
Category 2 value from a dropdown,
and the Inventory record is saved with the
Category 1 value,
Category 2 value, and the other values 1:1 dependent on
Category 2.
Okay, I can create the relationships between the tables, and I get the right value for
Category 1, but I'm not getting the data structure for
Category 2 set up right. I've read the online documentation for cascading dropdowns, but I'm missing something in setting up the fields. I have an Excel file with the relationships defined, but it's not working when I import it.
Can anyone help me with this?
------------------------------
Rob Vugteveen
Northwest Nevada
------------------------------