Join duplicate entries into single combo box?

[veekay]

I apologize for my first post here being one asking for help, but from the searching I've done I have been unable to find an answer for this (probably just using the wrong terms).

I have a table with many similar entries and I am looking for a way to reduce the numbers and "duplicates" without removing any entries. Here is an example of what I have:

What I'm trying to do is get this into a single row, but with the different entries for the Cust field to be in a combo/dropdown box. Id and IdName will always match.

I do very little access stuff, but a nudge in the right direction would be appreciated

 

[MarkK]

Hey, welcome to the forum.
The term you want to search on is Normalization, and you'll get tons of results. Normalization is the art and/or science of eliminating duplication or repetition from your data structures.
What you've posted can't be in a single row because there is unique data in the Cust field of each record. That data should be in its own table with three rows, and the remaining data would then be a single record.

 

[pkstormy]

If you don't have the option to make the normalization changes as lagbolt suggested, your other option is to create a field in the table which 'concatenates' 2 or more field values together and make this field unique or a primary key to prevent duplicates. I'll sometimes use this trick as a quick fix when I can't make in-depth changes to the design to normalize it correctly.