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?
 
gnetgnetConnect With a Mentor Commented:
SELECT DISTINCT t.cTypeID FROM tblTypes AS T INNER JOIN tblContact_Primary AS M ON M.cTypeID =  t.cTypeID;
0
 
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
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
dqmqConnect With a Mentor Commented:
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
 
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
 
caseyuAuthor Commented:
GNET got me the final answer but both helped out so I am splitting the points.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.