John

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.