>>>Hi, Phil!
>>>
>>>What about dealing with
LOCATE FOR rec_Id = m.MyId
>>>LOCAL loScatter
>>>SCATTER MEMO NAME loScatter
>>>APPEND BLANK
>>>
>>>#IF If you have a Default functionality to fill primary key
>>> * take the id generated by the default functionality during APPEND BLANK
>>> loScatter.rec_Id = rec_Id
>>>#ELSE
>>> * changing the primary key
>>> loScatter.rec_Id = <whatever>
>>>#ENDIF
>>>
>>>GATHER MEMO NAME loScatter
>>
>>Thanks to both you and Hilmar!!
>
>Hi Phil,
>
>In addition to these suggestions I have a label on the top of the form, which said: "This is a cloned record". Sometimes user becomes confused, so it would be helpful to have a visual clue. Don't forget to make this label invisible once you save or move to another record.
Hi Nadya,
Good suggestion. I realized the same thing, and added a messagebox after the gather that says (in effect)"The duplicate has been added and is ready for you to save/cancel. Click OK to return to the standard save/cancel nav buttons."
Thanks again to all for the help. I have saved two employees each about 2 hours per week with this implementation!! All it took was about 3 hours of work :)
Phil Thomas
http://phillipdthomas.comNever let your energy or enthusiasm be dampened by the discouragements that must inevitably come.....