My original post about records lurking in tables when they hadn't been saved (which turned out to have a name - 'abandoned records') was lost in the recent Restore but I wanted to report on the outcome.
Bruce explained why this happens and gave pointers on how to deal with the situation, very useful.
I opted for adding a 'Valid' field on all of the tables together with a 'Created Date' and setting 'Valid' to TRUE on 'Save'. Adding a filter on the browse for that table to exclude Vaild = FALSE and a management routine to delete old invalids looks ok.
Thanks Bruce (and Kevin for tips).
Cheers
Keith
Topic: Abandoned records (Read 3374 times)