How do I "Copy" and "Paste" child subform records in details section?

[hartattack72]

Hello. I am new to access, but have had great success in creating an application. My one user is requesting a function to save time in data entry... and I am stumped being the plebian that I am.

My application is used to enter land owner information by parcel (40 acre lots). For example: for parcel #1 someone owns the land, someone owns the mineral rights, someone owns the water rights, etc, etc... and we inventory about 36 square miles of land (about 600 parcels) for now.

My master on the form is the Parcel ID, and the child subforms are the different categories of ownership (surface, mineral, etc) sorted by their legal descriptions (Parcel ID - which includes Township, Range, Section, QQ).

I want to create a function that works like copying something to the clipboard, but I would be "copying" the current records in the subforms so I could "paste" them into a different Parcel ID record.

Here is my question:
How can I copy all the records on a subform (using a click event), find a different record (parcel), and then "paste" them into the same subforms (using a click event)?

Keep in mind I will need new auto numbers.

Do I store them as a variable? Use an append query? If someone could start me off on the right foot, I would be grateful. If you need more details I will provide.

Thanks,
Adam

[nico5038]

Copying data isn;t the way to go in a normalized database.
You should identify the "corresponding" fields and create another table with an autonumber ID for them.
You can see the Northwind.mdb as a sample. Not every order will hold the Customer Address information, there's a tblCustomer and there's the address. The order just holds the CustomerID.

The same way you need to rethink your tables.

Getting the idea?

Nic;o)