I am modifying a contact list for my company, and right now there are 6000 records already present. Right now as it is setup, when entering a contacts company, you need to enter the company and the address. Normally I would just have it set up so that when the company is selected it automatically would add the address. However sometimes there are multiple addresses associated with each company.

So what I am going to try and incorporate is have two lists, one for the companies and one for the addresses. I am hoping to be able to filter out the address list based on the company. (I hope I have explained myself clearly)

To add/confound the problem is that when the previous contacts were entered they weren't done to any form (sometimes companies are in Caps, other times they are not, sometimes typos). Should I even bother trying to filter these records as well?

Any advice would be greatly appreciated

I should also mention that I'm hoping of using the already entered company names and addresses instead of retyping everything