Multi scan rpt without field in database

[Jody_Yniguez_(Guest)]

I need to create a multi scan report for collecting data from two separate data files. My problem is that one of the files does not contain the necessary field (acct_no is the field name in the master file which contains sales account number), so I created a calculated field with a lookup into another file to retrieve the appropriate sales account information. However, the calculated field is not available when setting up the database relation. ____Is there any way to do this without actually adding the field to the database? I would appreciate any direction.

[kfleming]

So you are using a calculated field that uses the LOOKUP() function?____Kathleen__R&R Support

[Jody_Yniguez_(Guest)]

Yes - I created a field using CLOOKUP() into the file (file is called DEFIN) that contains the Sales Acct # for the records in the original file (file is called JOBHLABR) - these two files are linked by a field that is in each called WORK_CODE.____Thanks for your quick response!!

[kfleming]

If you use a regular relation in place of the LOOKUP() calc, then you will be able to set the next relation.____Kathleen__R&R Support

[Jody_Yniguez_(Guest)]

I^m sorry to be dense - I tried to figure out what you meant here but I cannot. If I use a lookup from the jobhlabor to the defin file to get the correct sales account number, I don^t understand what to do next.