I am using a database which was supplied to us by a software vendor which allows me to program routines when dealing with records. I have record which is alocated a unique number for example 00001. When I copy this record I want to record the unique number this record was based on. For example I browse for the record I want which is displayed on form number 00001 when I click copy and then save it asks me for my new number which is 00002. therefore in the field which is named moc042 I want to display 00001 so I know where the copy has come from. I have created the coding for this which is:

REPLACE WORKSTYLE.MOC042 WITH WORKSTYLE.KEY3

The problem here is that when the copying is executed it copies the value of key3 to the moc042 field for the new copied record. I need to somehow store the value of key3 prior to the copy and then when the new record is created it recalls the value of the key3 field in this case 00001 and stores this against the record 00002 in the moc042 field. I need to somehow determine the current record in the syntax above.

Many Thanks in Advance