combining two tables

[Mary]

Since starting to work from home, a coworker has been taking home a backup
copy of our database. I gave her instructions to work on only one form and
not to touch any others. I have just found out that she spent the last week
and a half working in a different form.

At this point I have two tables that are identical, except that one has more
information than the other. I tried to import her table and delete the one
with less information, except that the table she updated has many
relationships as it is the most central table in the database.

I have explored update and append queries and do not know what I need to do
to fix this. I need to import her data to my existing table.

All helpful suggestions are appreciated!

 

[Dorian]

If there is an autonumber key involved, you have a problem.
If not, you can do a copy and paste.
Otherwise you will need to note the relationships before deleting them all.
Then replace the table with the new one, then reinstate all the
relationships.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[Mary]

Thank you! You saved us!

If there is an autonumber key involved, you have a problem.
If not, you can do a copy and paste.
Otherwise you will need to note the relationships before deleting them all.
Then replace the table with the new one, then reinstate all the
relationships.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".