I've been searching too long for this ... so I figured I'd throw it out to the EXPERTS and see if it's a simple fix.
I have a contacts database with a Primary Key called ID. I have 6 other tables linked to the Contacts table using a field called ContactsID, which contains the ID of the record in the Contacts table.
Now I have duplicates ... and what I want is a simple update query that changes the value of the ContactsID field in the subtable from the record I want to delete, to the record I want to keep - thus moving all of the data from the duplicate contact to the contact I will retain.
Is there an easy way to change the value of the ContactsID field for all records containing ID 6974 to ID 1044?
I will deal with the duplicate contact record in a different way, at this point I