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