Trouble With Information That keeps repeating

[RoundTrip]

As you can tell I have two problems, I have a combo box for Location, and a combobox for Equipment Number, Now I have a problem with these two combo boxes, I have the Row source coming from a separate form and the Row Source Type a Table/Query. Now as you can tell I have a problem of repeating information, how do I make it where it only says Shelby once, and etc for my EquipmentNo problem. So if you guys don't mind pointing me in the right direction of what to do. If you guys need any more information, just let me know please! Thankyou guys ahead of time for everyone helping.

[June7]

Options:

1. Have tables of these unique values and use those tables as sources for the combobox lists

2. Use DISTINCT qualifier
SELECT DISTINCT Location FROM tablename ORDER BY Location;

[RoundTrip]

Hmmm, thank you for the quick response! I am not trying to get you to spoon feed me, but the person who usually helped me on access has moved and I can't really ask him questions about things anymore, so if you do not mind me asking what is most likely stupid questions to you, but what exactly do you mean about a unique value? Do you mean the primary key or something else? I am taking it that according to the order you put it in, you would choose number 1 as the best option or?

[orange]

Did you try to change the RowSource of the combo as June7 suggested?

DISTINCT === Unique
The SELECT DISTINCT statement is used to return only distinct (different) values.

Instead of showing 20 or so Shelby, just show 1.

[June7]

Option 1 is the more conventional approach but I do use option 2.

Unique means there is only one record with that value.