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”