>Dear all,
>Just completed a conversion of our app to SQL database from VFP6.
>A lot of the reports done were using set relation to master files to grab description/names.
>With the SQL database where we no longer can utilise "set relation" to grab these descriptions, (e.g. report cursor contain customer code only, looks up to customer master file to grab customer name). Besides using sql to join tables (in this case, a lot of tables), are there any other ways that we can use ?
>Thanks in advance.
>Yau
Having tables in SQL server doesn't remove "set relation" capability. However even in pure VFP creating cursors for report is a better choice than "set relation" IMHO.
If you want to use "set relation" you can still do it getting data from needed tables into cursors (be it SPT,RV or CA cursors).
Cetin