RobVugteveen
6 years agoQrew Member
Cascading Dropdowns
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
------------------------------
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
------------------------------