Combo Box to display ID's used only

I am trying to create a combo box that will only display the ID's that have been used on the master table. I have one table called customer type that gives a unique key and description for customer types. When the master table is populated with customers the users choose from a drop down list that is populated with the unique ID and description from the Customer Type table.

Now I am in the process of creating a multi-parameter query that will display customers based on what the user chooses from multiple combo boxes on a form. The challenge I am running into is there are some customer types that have not been used yet. I need that customer type combo box to only show the ones that have been used on the master table, not all of them from the Customer Type table.

I have searched and searched this board, in fact I have spent the last couple hours doing so, trying to find my answer and keep coming up empty. It is probably in how I am doing my search of the board, but I have tried several combinations of words and still cannot seem to find the answer. I know it is probably something simple but it is costing me a lot of time to find it.

Thanks,
caseyuAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

gnetgnetCommented:
Can you share the query and the tables layouts?
0
gnetgnetCommented:
If your query has a join between the 2 tables,  only the ones that are on both will be included
0
dqmqCommented:
Make the rowsource for your combobox like this:

Select t.* from CustomerType as T inner join MasterTable as M on M.CustomerTypeID = t.CustomerTypeID


Of course, you need to substitute your table and column names
0
The Five Tenets of the Most Secure Backup

Data loss can hit a business in any number of ways. In reality, companies should expect to lose data at some point. The challenge is having a plan to recover from such an event.

caseyuAuthor Commented:
I have been accused of this before and a lot of the time it is true since I am not always 100% sure how to ask for what I want, but I might not have been very clear. On the combo box for the multi parameter query, I only want the Customer Type (cTypeID) to show up once if it exists on the Master table. Below is the copy of the code that I entered in the row source. I got it to give me a list but it is giving me the cTypeID for every customer that is in the master table, not limiting it to 1 if it exists on the table.
0
caseyuAuthor Commented:
SELECT t.* FROM tblTypes AS T INNER JOIN tblContact_Primary AS M ON M.cTypeID = t.cTypeID;
0
gnetgnetCommented:
try select distinct only selecting Cust type, not *
0
gnetgnetCommented:
SELECT DISTINCT t.cTypeID FROM tblTypes AS T INNER JOIN tblContact_Primary AS M ON M.cTypeID =  t.cTypeID;
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
caseyuAuthor Commented:
GNET got me the final answer but both helped out so I am splitting the points.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.