I am wanting to duplicate a record and not sure how to do this. I would like the entire record to be duplicated using old values when the user changes the revision number of the record. For example, if the user opens up an existing record and amends the revision number field from A to B, I would like the entire record to be duplicated using the old field values (revision A) before the amendments where made.

During this event I would also like to change the 'superseded' field from the default 'false' to 'true', thereby allowing me to only to show current versions of all records within my report using the 'superseded' field as the filter.

I need to replace the 'alert' statement with the code to duplicate my record using the old values.

Any help on this would be greatly appreciated.

Regards

Martin