turning dupicate records with one different field into one record

[marlin123]

I have a database of 10,000. some people occur 5 times in the database with five different product codes. like the following:-
John Smith 23 Smith St, Smithville. bb1
John Smith 23 Smith St, Smithville. bk1
John Smith 23 Smith St, Smithville. hu1
John Smith 23 Smith St, Smithville. hu2
John Smith 23 Smith St, Smithville. pl1

What I want to do is get the database to look at the first field and if it has already occured then duplicate the code field at the end of the previous occurrance of the record. Therefore increasing that record by one field. Or even just adding that code into a code field.
Then I end up with onrecord like the below.
John Smith 23 Smith St, Smithville. BB1 Bk1 Hu1 Hu2 Pl1 [sig][/sig]

 

[jagilman]

What you want to do is able. However, would you be able to split the table into two tables? One table would keep the customer information and the other would keep the product information. If you plan on keeping the table like it is then will the extra product information be added to an existing field or do you need to keep it in a seperate column? [sig]<p>John A. Gilman<br><a href=mailto:gms@uslink.net>gms@uslink.net</a><br>[/sig]