>- How do I access the SQL data? Do I have to create views for every table?
That is one way, and probably the easiest to get started.
>- How can I use the indexes in the SQL database to order my data?
Views are essentially SQL statements which, of course, can be ordered. However, you can index views if you need more flexibity.
>- Are there any 3rd party products which will allow me to manipulate the SQL data as if it was a local Foxpro DBF?
I use a VFP framework named Visual FoxExpress which allows me to quickly write applications that use either native dbfs as well as SQL Server data (or both). There will be a learning curve (especially since you say you are new to objects), but they have very good training CDs to help you get started. For info on that, go to
www.f1tech.com>- Is there any place I can go to read about this subject?
See this link for starters.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fox7help/html/dgusing_sql_pass_through_technology.aspAnd though it's a bit dated, you can consider purchasing this book...
http://www.hentzenwerke.com/catalogpricelists/csvfp.htmHope this helps...
Del