Free Lessons
Fast Tips
Topic Index
Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon  
Home > TechHelp > Directory > Access > Cascading < Loan Payments | Vehicle Maintenance >
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   9 months ago

Back to Cascading

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

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:



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

Start a NEW Conversation
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

You may want to read these articles from the 599CD News:

5/27/2022Add Anything
5/26/2022List Items Edit Form
5/25/2022Column Colors
5/24/2022Multi-Table Forms
5/21/2022Access Developer 39
5/21/2022Access Developer 39 Lessons
5/21/2022Access Developer 39
5/21/2022Select Items in Related Table
5/21/2022Clear List Box

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn