>>It is an accounting system.
>>Each folder would be the books for a different company.
>>I want to use remote views for the connection to SQL Server.
>>I want to use local views for Fox.
>>I want to be able to use the same forms for connecting to both SQL and Fox.
>>
>>The database tables would be identical in Fox, just stored in different folders.
>
>You should probably have a different dbc for each company; different dbcs with identical views pointing to different data. You can use the same form to access different sets of structurally identical (or similar enough) data.
>To do this, all you need is a routine that runs from the BeforeOpenTables event of your dataenvironment that loops through the cursors in the DE and changes their Database property according to what dataset you want to use. Local, Remote, whatever, the form doesn't care. Let me know if you would like some code that does the database switching for you.
Great minds think alike :)