I am using MS ACCESS, and have 4 tables to update, from 2 different tables/spreadsheet
tb1- Client Index, Name, address and zip.
tb2- user index, Sales rep, client index
tb3- user index, Managers
tb4- client index, Sales Target
Master 1 has Name, address, Sales target and sales rep
Master 2 has Name, manager, zip
So, I need UPDATE the records as per:
From master 1 to tb1 with the client index (auto increment), name, details.
The idea is the above, but.. Can anyone help me with this? (translating into a MSACCESS/SQL entry)
I am sorry.. it is a bit complicated, and it seems to be a bit too much for a noob!!!