Chuck,
I'm not sure what the 'SCATTER' is doing. You might check the "Blank" command to blank all fields in the recalled record.

Don't forget that if Set Deleted is ON that you will never find a deleted record - something I've forgotten on occasion.

I'm assuming that you either have a very small file or an index on deleted() since you're using 'LOCATE'.

You don't mention if you're using buffering at all. If you are not, then you are running a serious risk of having 2 records with blank ID fields because 2 users have clicked the ADD button at the same time. Buffering is a GOOD THING and (IMHO) should always be used.

HTH
Barbara


>* Authform ADD ClickEvent (Parent)
>
>SELECT person
>LOCATE FOR DELETED()
>IF NOT EOF()
> REPLACE id WITH ''
> RECALL
> SCATTER
>ELSE
> APPEND BLANK IN person
>ENDIF
>
>Is this the correct way to do this? Or there is something missing or should not be there (SCATTER?)? BTW, the ID of the person table is primary key (can not be duped). Thanks for looking at this code and correcting it (if any).
>
>Chuck