Is it possible to have a three-way cascading combo box?
For a database for a small museum, I have a set of two cascading combo boxes, the first for a particular artifact's general category (like communication artifact, or a personal artifact etc) which affects the contents of the subcategory combo box which lists more specific items relating to that category.
There is also a text box area for the artifacts simple description entitled "object" - entries in this would be box, hat, shirt, etc.
I have run across an official goverment list of possible object names which would prove to be very efficient when it comes to querying for specific objects.
Right now I have two tables - one with the list of the category names with an autonumber column assigning a unique number to each category.
I have a second table with the SubCategory's names also with an autonumber assigning a specific number to each subcategory. Also was a column with the corresponding Category name for each Subcategory.
I have a query set up for both text boxes that selects entries based on all of the relevant entries in the two tables.
Do you guys have any suggestions on how to make the next step? Would I simply be able to "copy" the code I used for the subcategory box and use it for the object box as long as I have the necessary data in a proper table?
Thanks for your support!
For a database for a small museum, I have a set of two cascading combo boxes, the first for a particular artifact's general category (like communication artifact, or a personal artifact etc) which affects the contents of the subcategory combo box which lists more specific items relating to that category.
There is also a text box area for the artifacts simple description entitled "object" - entries in this would be box, hat, shirt, etc.
I have run across an official goverment list of possible object names which would prove to be very efficient when it comes to querying for specific objects.
Right now I have two tables - one with the list of the category names with an autonumber column assigning a unique number to each category.
I have a second table with the SubCategory's names also with an autonumber assigning a specific number to each subcategory. Also was a column with the corresponding Category name for each Subcategory.
I have a query set up for both text boxes that selects entries based on all of the relevant entries in the two tables.
Do you guys have any suggestions on how to make the next step? Would I simply be able to "copy" the code I used for the subcategory box and use it for the object box as long as I have the necessary data in a proper table?
Thanks for your support!
