>I'm sure you know that recno() will return a negative number if it's buffered. Is there a relationship set between that table and another?
I was wrong, the record is indeed in the table - I was not seeing it before using browse command, so I ran a select.
In fact, that's what I found the previous time working on this problem - that the table had duplicates. This time I somehow thought it's a fantom record.
I need to find out how these duplicates are created.
If it's not broken, fix it until it is.
My Blog