>Thank you - I like that!
>
>Now - what if the data entry is done using a local view? As far as I can see any new records created in the view are always going to create new records in the underlying table when TABLEUPDATE() is used.
>
>I'm just wondering if some of the deleted records in the underlying table could somehow be included in the view when it is REQUERY()ed, then quickly deleted in the view before the user sees them. Then they could be made available by recalling them as the user requests a new record...sounds a bit unlikely though!
You could find a deleted record in a table,
set deleted off
Locate for deleted()
if found()
Blank field all except PrimaryKeyField
Recall
else
< create a new record here >
endif
set deleted on
and finding a way to include that record in your view is now your thing to do.