It's laziness to me write USE (SET RELATION) for open the tables in not visual utilities. I think easier to create appropriate DataEnvironment  in Form Designer... and use my GenDE http://vfpdmur.narod.ru/download/gende.zip (90,5KB) [the GenDE utility allows in VFP 6.0 to receive the code of definition of DataEnvironment classes for the forms from the indicated folder. The resalt is made out as the prg-file. Now allows to create appropriate classes Session also]. The example of using creates as comment in received prg-file as a result...
It uses some number of the tables... and I suspect, what for not the Russian users will have some problems with SET COLLATE "?" and CODEPAGE :-( However, I think for VFP-programmer it not a problem to change it to the own country setting. About using SET COLLATE & CODEPAGE see also http://vfpdmur.narod.ru/docs/cpcl_e.html [some notes concerning use Code Page and Collate Sequence]
[as addition, you can use  utility CP1251 for resetting CODEPAGE all files in the folder (subfolder) from my site]
This version (ver. 2.0.2) allows create a code of DataEnvironment classes for VFP-database (i.e. when as an input file the dbc-file) is indicated. But it's meant, that for organization of intertabulared relations the composite indexes are not used. The method of creation of class SessionDE as class of vcx-library is shown also. In more detail see AboutLibSeEn.txt 

In version 2.0.3 the property Name in a class, derivative from DataEnvironment coincides with a name of this derivative class, whereas more earlier version had value "DataEnvironment", that could reduce in problems.

As I hope, this utility will allow to reduce hand-operated work for you.

Michael Drozdov, ICS Soft, Perm, Russia
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~
Mailto: Drozdov@ics.perm.su
My Page: http://vfpdmur.narod.ru/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~
