Long topic title… sorry.
I have a table of employees that are linked to various other tables.
At times, duplicate entries have been created in error or linked records attributed to the wrong person.
Is there a way, from within the employee table, to take all records from one linked field and paste them into another employee record, without overwriting what is there?
Julie Smith is duplicated in error. There is a table called clients.
Julie Smith (record 1) has 50 linked client records.
Julie Smith (record 2) has 20 linked client records.
I want to move the client records from Julie Smith (record 2) into Julie Smith (record 1). If I cut and paste the 20 records, it overwrites the existing 50 records.
This is true for 5 other linked tables across several records.
I can change the name of Julie Smith (record 2) to “Fix Julie Smith” and then paste over every record in the 5 linked tables. But, I’m providing a single example of this occurring. I’ve taken over administration and development on a base that has been in use for nearly 2 years and has numerous data integrity challenges.
It would be significantly easier to do this inside a source table and move linked data to consolidate records.
I hope this was explained clearly. Any insight is greatly appreciated.