Page 1 of 1
Multi scan rpt without field in database
Posted: Thu Jun 21, 2001 6:45 pm
by 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.
=> RE: Multi scan rpt without field in database
Posted: Fri Jun 22, 2001 4:44 am
by kfleming
So you are using a calculated field that uses the LOOKUP() function?____Kathleen__R&R Support
==> RE: Multi scan rpt without field in database
Posted: Fri Jun 22, 2001 12:36 pm
by 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!!
===> RE: Multi scan rpt without field in database
Posted: Sun Jun 24, 2001 12:59 pm
by 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
====> RE: Multi scan rpt without field in database
Posted: Sun Jun 24, 2001 5:42 pm
by 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.