I
IT
I am currently working on a database that stores information on 400+
companies. Problem is: Companies that have more than one location/address
have different records for the headquarters, subsidiary, sales office etc. I
end up having 2-6 records for, say, Company A. When I update the sales figure
for Company A, I need to do it 6 times. How can I merge the records for
Company A or somehow specify a master records for COmpany A? I would
basically like Access to auto-update each record by just entering the data
once on a "master" record for Company A. Any advice would be greatly
appreciated.
companies. Problem is: Companies that have more than one location/address
have different records for the headquarters, subsidiary, sales office etc. I
end up having 2-6 records for, say, Company A. When I update the sales figure
for Company A, I need to do it 6 times. How can I merge the records for
Company A or somehow specify a master records for COmpany A? I would
basically like Access to auto-update each record by just entering the data
once on a "master" record for Company A. Any advice would be greatly
appreciated.