Hey guys and gals,

what would be the best way to go about copying/cloning a record from a table. I want the user instead of having to type everything in over and over again i want them just to be able to clone a record they already have in the database.

One thought i had, was to make a temperary table copy the record, drop the id (because the table uses an auto increasing id) and than re-insert into the database. Any thoughts?