pasting fields in a query based on 2 tables

[Database User]

Hi i have 2 databases that are exactly the same. One is in the office and one
is at home. They aren't updatable on a server or anything like that. The main
one is in the office

The problem is that when i want to transfer all the records from the one at
home back into the one at work so that all the data should be in one place i
have records in a table called customers and related records in a customers
actions table. How do i paste it all in.

I was trying to do it all in one go but it didn't work. do i have to first
paste in the customer information in the customer table and then the actions
- will that work?
does anyone have suggestions?
thanks a lot!!

 

[tina]

any time you're appending records to related tables, you must follow the
relational hierarchy - parent tables must receive the records before child
tables receive theirs.

hth