I am relatively new to using VFP7 with SQL server. I have expermented with both Remote view and SQL pass through. I am having trouble creating a form entering data then saving is to the SQL Server without going through alot of steps. The database has over 2,000,000 rows so obviously I have to be careful not to down load it to a view. I have tried remote view and a form with a data session with nodata = .t. but then I am not sure how to add a row and save data. Does anyone have some sample code or ideas.

Thanks

Tom