Duplicates

[amyr74 via AccessMonster.com]

I have a form that has a drop box which pulls from a table of contact info.
In that table there are multiple names with the same company name. How can I
make that drop down box only show the company name one time?

 

[Guest]

First, just an observation:

You should take a look at the design of your database. You need to have the
company info in one table and the contacts for each company in another table
with a foreign key to the company table.

Once you have your data normalized (do some research on "Normalizing a
Database") then you can use two combo boxes to accomplish what you want to do.

You could actually probable get the result you are wanting with the data
like it is now, but you need to learn about normalization first.

When you are ready, you will have one combo box that shows a unique list of
company names. Then the second combo box will show a unique list of contacts
using the value selected in the first combo box as its criteria.