Mass copy of Parent and Child records

[hooi]

I have tables as follows:

Parent(Bill ID, ...)

Child(ID, Bill ID, ....)

Now there is a set of records in Parent with their related records in the Child table. I've been trying to do mass copy of records from the previous month to the current month, this is so that my user doesn't need to do laborious individual data entry of new records which are pretty similar every month (eg. Bills from Telecom).

I'm not familiar with VB programming. I've been trying to use Macro to achieve what I want and have been hitting difficulties in that even though I'm able to do mass copy of Parent records over (using Query), but the related Child records cannot be copied easily as the auto-generated Bill ID (fromo the Parent table) has to be copied as well.

Could anyone advise as to how this can be achieved?

Thanks a million...

 

[hooi]

I've tried using the second query, but the problem is how to create new set of child records with their corresponding newly created (auto-generated) Bill ID (which is being used as foreign key in the Child table).