Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
Home > TechHelp > Directory > Access > Cascading Combo Boxes < Loan Payments | Vehicle Maintenance >
Back to Cascading Combo Boxes    Comments List
Cascading Combo Boxes Upload Images   Link   Email  
Bruno Segers 
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 
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 
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 

Bruno Segers 

Scott Axton 
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 
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 
Yes, you definitely need to set up a Many to Many relationship between companies and projects.
Bruno Segers 
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 
That is good news.  Thanks for the feedback!

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Cascading Combo Boxes.
 

 
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 3/28/2024 6:17:09 AM. PLT: 0s