Copying a database record with relations

I have 2 sets of tables in the same database - A live set and a test set. Each set has two tables in it - table A and table B - with a one-to-many relationship between them.I have 2 sets of tables in the same database -