I tested the search. I put "LOCAL" in a field in the Local VFP Tables and added a browse on the search cursor. The newly inserted records on SQL Server did NOT appear and the "LOCAL" text was NOT in the browse....indicating it was returning data from the server and still not finding the new record(s).

The issue seems to be that something in SQL Server newly inserted data doesn't return in the search???

Any Ideas? I see an Identity column in the conversion but not sure what it is and if I need it. Did not add it during conversion. Could that be an issue? Not that experienced in SQL Server.

Thanks,

Bill