>I use a connection string in the DB when I created the RV. The framework should handle everything. It is definitely accessing the correct DB as I can query the records converted previously. Only new ones are not found even though I see them in SSMS. The app creates the new record and it is visible on the server but not on the app. I also noticed any other child record also created is not found. If I update an old record and query it the update appears. That should indicate it is querying the right DB. I also noticed the inserted records are found somewhere in the table, not at the end of the table. I guess SQL Server inserts differently than VFP. LOCAL View files work with no problem when querying.

I'm not familiar with ProMatrix. However, I wonder if it's some sort of security issue.

If the app or the framework have user access or privilege control (i.e. users start by entering a user name and password), maybe new records are being added in the context of a different user, and are being filtered out by default in your app, or in the framework.

If you have an "administrator" logon for your app, do you see the issue if you use that account?