Brendan,
I have just reordered a database as I have been having trouble working out what my next record number is for creating the next. I need to have records in an orderly list. As there is no facility to set unique values for a field I have inserted blank records for missing or deleted records. However I have noticed that the record count is showing a higher number than actually exists! I think this must be because it is counting deleted records instead of just the current ones. A small issue but it should be possible to fix it. Many thanks.
Hmm… It shouldn’t count deleted records, but I’ll look into it. You can use the auto-increment function on the Number field if you need sequentially ordered records though. Then just sort your records by that field.
.
