Cascading in Microsoft Access

Cascading
By Richard Rost

9 months ago

Cascading Combo Boxes Upload Images Link
Bruno Segers
9 months ago

I have a new question following the video about combo boxes in cascade. I made a matrix table with all our companies and projects with yes/no results. If I want to place an order for a certain internal company I only want to see only the results in the combox where I have selected my matrix table "yes". So I should be able to establish the relationship in the form Company / Company column matrix before I can perform my "Like function -1" in the SQL statement.
The name of the columns in the matrix is identical to the company ID
Can you make a tech video of this?

Gtrz Bruno / Belgium - Gold member

Scott Axton
9 months ago

Bruno -
The question is a bit difficult to understand.  Possibly because of language difference? ( I don't see a location flag by your name so I'm guessing you are not in the USA )
I'm not understanding "matrix table".

I see that you have started the beginner classes but that doesn't tell us much of how experienced you are with Access.
That will help us out how technical or basic to be in responding to your questions.

If I understand correctly that you have multiple companies in the same database.
Company A, Company B, ...Company H?
Are the customers the same for all the companies?  How about the products or services?
So many questions and so little space!  Sorry.

It might help us if you take a screenshot of your db and post it using the Upload Images in the top right corner of your original post.

Bruno Segers
9 months ago

I made it bit simple and created a matrix table in excel. I hope that makes things a bit clearer.
When I make an order, I first select one of our companies in the form. As an example I take Company 2. Then I want in the combobox "project" only the results project 1 - 5-6
Can you help me how to build this SQL?

Bruno Segers
9 months ago

Scott Axton
9 months ago

Bruno -
In the Hide Inactive video Richard shows how to hide Inactive customers. IsActive is a yes / no field. I think if you take that same concept you can apply it to what you are trying to accomplish.

Scott Axton
9 months ago

I don't know what the structure of your tables are. You may need to create junction table to relate the companies and the projects together. One Project could use many Companies and each Company may have many Projects.
This is called a Many-to-Many relationship.

Take a look at these videos:

Relationships

Many-To-Many

Richard Rost
9 months ago

Yes, you definitely need to set up a Many to Many relationship between companies and projects.

Bruno Segers
9 months ago

Hey guys, I watched the tech videos this weekend and applied it to our application and it works perfectly! Thanks for the correct info. All projects are now neatly organized according to the selected company.

Scott Axton
9 months ago

That is good news. Thanks for the feedback!

Richard Rost
9 months ago

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to Cascading Comments