Why does admin detail page show record has been removed?
In previous posts this issue was related to missing records in the database and/or incorrect sql joins.
I've compared the admin detail page recordsets to the website's detail page recordsets (which don't have the error), and they look the same.
Also confirmed the database has the necessary related key fields.
After many JOIN attempts as well, I haven't found a solution. It only happens on a few records, and only on the detail page. The admin search results and update page don't have this error.