>Thanks for your reply. I think you are saying that from the free table program it would be best to create a DBC containing remote views of the customer file in the SQL DB? I'm not sure how to create a DBC with only views. But I'll check into how to get that done. With a remote view of the customer table I could setup some sort of routine that opens, closes, updates, and inserts into the SQL table????? I understand the free table program much better than the other program. BTW the free table program is SBT. Please get back to me as I need to do this next month. Thanks Mark!!!!
>
>John

All you have to do is CREATE DATABASE SOME_DB_NAME. Then MODIFY DATABASE to modify it to create/edit views. You first have to create an ODBC DataSourceName [DSN] through the ODBC Administrator found in the Control Panel -- assumption is that ODBC drivers for the backend have been installed.

You create a connection in the VFP DB using your ODBC DSN. From there, it is quite easy to create a remote view of a table and make it updateable. Your case would be very simple -- 1 table. In the view designer, you make the view updateable (Send SQL Updates option). Check all fields as updateable including the Key Field(s) if you are adding new records. Check the field(s) that are the keys.

Then you can create a form using this view as the data source for yuor controls. Then see the functions TableUpdate() and TableRevert().