Cascading combo boxes in Microsoft Access database

5 pts.
Tags:
Microsoft Access
I am a Continuing Education Teacher and I have been asked for help in building a function in a Microsoft Access database. I must say I have not yet found a solution. So, here what is needed: “I have constructed a contacts and networking database that I use to gather information on my professional correspondence and also industry activity (deals, etc.). I would like to build cascading combo boxes for two parts of the database. I am having trouble getting them to work as I wish. Correspondence Cascading Combo box: In order to improve accuracy, I have created a query that concatenates the first and last name of Contacts in my Correspondence Form. I would like a Combo Box that references the Company Field and provides employees names only from the Company selected in a Concatenated form. I have been able to get the concatenated names to appear in the “Full Name” field from the query, but I have been unable to filter them by Company. Company Cascading Combo Box: I would like the Company Table and Form to have cascading combo box’s for Sector, Industry and Segment. Each Company operates within a Sector, Industry and Segment. For example: Sectors = ‘Oil & Gas’, ‘Basic Materials’, ‘Industrials’, ‘Consumer Goods’, ‘Consumer Services’, etc. Industries are subsets of a Sector. For example, the Industries for the ‘Consumer Goods’ Sector consist of ‘Food and Beverage’, ‘Household Goods’, ‘Leisure Goods’, etc. And then if follows for Segment under the Industry. I am not sure the best way to build the cascading combo boxes for these. I have set up several tables with each Sector, Industry, Subsector, etc. It may be better to just have one table be referenced with multiple fields. I am just not sure the best way to organize the data and construct the Company Cascading Combo Boxes to work. I hope I have been clear in my explanations of the functions I would like to achieve in my database”

Software/Hardware used:
Microsoft Access

Answer Wiki

Thanks. We'll let you know when a new response is added.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following