I'm attempting to create a VFP front end to a SQL Server(7) DB. I'm new to VFP and am unfamiliar with many of the strategies involved with setting this up.

The DB I need to interface with is not very large. It consists of less than 10 tables, most of those having less than 10 fields. To simplify database referencing, I have ensured that each table contains integer PK's, thus all FK's are relations via integer reference.

My first inclination was to use strictly Remote Views to access the SQLServer DB. I have the ODBC connection setup correctly and can retrieve info via these remote views. However, in creating forms, and reports, I'm running into problems (with the GUI design tools) when they are asking specifically for Tables, (one example is trying to set up a 1-to-many report; it wants a TABLE for the child relationship).
Another problem I'm having using the remote views is in implementing queries, (I tried to create queries for the reports before using views, but I was receiveing error messages when I tried to use a parameter in the query). Note that I haven't tried to create forms/views/queries via code, only with the VFP GUI designers. I unerstand that you may have more control over creating these objects via code, but was hoping I could use the design tools until I was more comfortable with VFP.
I have many questions regarding this, but let me start with this: Can I use ONLY Remote Views to create my forms, reports, and queries, (basically, for the entire project) or do I need to create local views, free tables, etc in order for this to work. Currently I can't think of any data that won't be contained on the SQLServer end, so I don't know why I would need extra tables (free or local).

Any information, suggestions regarding this would be greatly appreciated!

Thanks in advance!

(Oh yah, I do have (and have read) three of the major VFP6 books; "VFP 6 Enterprise Development" by Paddock/Peterson/Talmage , "Hacker's Guide to VFP 6" by Granor/Roche , and "Effective Techniques..." by Booth/Sawyer. I know these questions may be very elementary, but, as I said before, I'm new to the VFP environment and need all the help I can get.)