Tweaking a current contact list
I have a current filemaker database created by someone a while back - this is for contact management - There are a lot of tables involved which I don't want to touch because they work well for the company's invoicing and shipping. I just want to be able to lessen the work because there are so many contacts under the same company but not all the addresses are filled up in each or sometimes they miss out a number here or there. Is there a way for me to just change the field to select the company name so that the main address of the company gets filled up automatically? I'm just more interested in populating the main company details, the rest of the information per customer can stay as is.
Do I create a new table or a self table? and where should it be linked? Each customer has their own ID, and some have multiple shipping addresses in each record.