Multiple Cascading Combo - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Multiple Cascading Combo

Matthew McHenry

4 years ago

How can I enter data into table using a cascading combo field to limit chooses.

For example, I want to enter our products that we carry. We are a furniture business so my plan is to have a room, type, style, color, manufacture categories. I want to be able look at reporting to compare different category in the future.

Examples
Room.     Type.       Manuf.   Style.        Color.
Bedroom. Dresser. Liberty.   Freedom. White.
Living.     Sofa.       Klausser. K7610.     Cream.
Dinning.  Table.      Liberty.    Stevie.     Black.

So some manufacturers make cover different rooms but most dont. Style is very dependent on type but also manufacturers. Color can repeat but fewer options in bedroom vs living. Everything is dependent on room selection.

I trying to enter the choices for styles into the styleT. I have not gotten to productT yet.

	Kevin Robertson @Reply 4 years ago
Cascading Combo Boxes

	Matthew McHenry OP @Reply 4 years ago
I watch than one but when I want to make the third tiered of the cascading tables do I have to keep reinventing the cascading combo from the second tier?

	Scott Axton @Reply 4 years ago

	Scott Axton @Reply 4 years ago
Think of it more like the Matryoshka dolls you just keep revealing layer upon layer until you reach the last one but yes you just keep stepping down the line. Another example - and a different way to think about doing this the Nested Continuous Subforms video. Similar concept just a alternate view.

	Richard Rost @Reply 4 years ago
Instead of using queries like I do in the TechHelp video, it's much more flexible if you know how to write custom SQL row sources for each of your boxes. That's a lot more advanced though. I cover that in Developer 6.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View