Clone existing record

  • Thread starter Thread starter Razor
  • Start date Start date
R

Razor

Hi,

I need to be able to

clone an existing record in a table,
update the original record and
update the coloned record

based on certain criteria.

Could someone show me how to do this via VBA?

Thanks,
Razor
 
Cloning a record is generally not the way to go, in a relational database
like Access.

Say you clone a record having 10 fields A-J. Say you alter fields H, I & J
in the cloned record, but you leave fields A-G unchanged. In a relational
database, you should really store fields A-G in a single record in a
higher-level (master) table. Then, you have two records in a "child" table,
for the fields that vary.

Maybe do some research & reading on the concept of "database normalization",
which covers all this.

HTH,
TC
 
Back
Top