copy records to another table

Hi,
I was wondering could you help me.
I have 4 tables

'A'
'A-details'

'B'
'B-details'

Table 'A' is in a one-to-many relationship
with 'A-details'

as is
Table 'B' in a one-to-many relationship
with 'B-details'

Both sets of tables are in forms with subforms
ie FORMB has mutiple records from 'B-Detail' displayed.
What i want to do is create a button that will copy the current record from table 'B' and INSERT it into table 'A' at the same time
copy the associated 'B-details' into 'A-details'

Can some one help

thanks in advance

Anthony

You can use two append queries to do the job. One to append TableA with TableB's filtered record and do the same for TableA-Details with TableB-Details filtered records. The only drawback is if TableA already has a primary key value from TableB then you will get a key violation, so you will need to create some work around if that is the case.

BTW, why would you need duplicate records in your database anyway?

lwells