>Thanks Mike,
>
>Fortunately my system uses unique surrogate keys.....About the only things good. My app doesn't use views so I will probably re-write it using CA's. Also I must figure out how to change my code to address data commands in SQL instead of the usual REPLACE, etc. Fun!
>

Actually, you still use REPLACE etc. on local copies of the data.
It is a beautiful thing.

Most of the xBase commands are still very useful.
The one caution is that you cannot SEEK into a full table - only your local temporary copy of a small subset of the data.

Get familiar with TableBuffering and TableUpdate()
You do have to make sure to issue TableUpdate() to send the changes back to the SQL Server.