Copy record in same table

[Msmartine]

Thank you both for your time and feedback. I will consider both approaches. I believe the version approach jdraw mentioned will simpler.

 

[Gasman]

Thank you both for your time and feedback. I will consider both approaches. I believe the version approach jdraw mentioned will simpler.

Have a default of 0 for VersionNum in the table.
Then just use Dmax() to get the latest and add 1 to it.

Make a unique index of ID and VersionNum to avoid potential duplicates.

Anyway, good luck with your DB.