Combining Records

[paulm]

Hi

Currently in our database we several companies entered several times. Due to different branch addresses. What we are looking to do is create a form that combines displays all the addresses related to that customer name.

Does anybody know of a way we can do this?

Regards

Paul

 

[Pat Hartman]

Sounds like its time to restructure the database. If companies have moe than one branch, you need a lower level table so you can have 1-company to many-branches.

With your present structure it doesn't sound like you have a way of identifying a company except perhaps with company name. The problem with this of course is that the name field is unreliable as a matching agent do to the various ways that names can be entered. My Company Name, My Comp. Name, My Co. Name, etc.

 

[paulm]

Thanks for your reply Pat. Part of me already new that the other half hoped no one would come up with that