I have a Line Items table that has 11 records in it. However, on layouts based on this table, it says only 10 records exist. All 11 records are related to the same Invoice, and if I perform a find using the invoice number, 11 records are found.
So far, I have yet to find the cause of the issue. I deleted the parent record, which used a cascading delete to delete the child records, including the problem record. I then recreated all of them, and everything works just fine. So for now it appears to have just been a one-time fluke.
I seem to remember at least one discussion about this sort of thing on the FM (now Claris) Community: https://community.claris.com
A search for phantom records throws up a few possibilities—
I was in the process of upgrading a customers database to the latest version and noticed this same issue. It showed 64 records but if I did a search it would find over 1000 records.
I am glad this is the first time I have seen it and hope it is the last time.
I thought I remember somebody claimed that this occurrence is related to corrupted index.
File recovering OR set index off and back on for related key fields (Storage Options, Indexing None /All) was recommended to fix.
I did not try to turn off index but that dose seem to be what the log suggested when I did a recovery. Though the logs are anything buy clear too me. I am still doing testing to see if any data was lost but recovering the database seems to have worked.