Liveware Publishing Support Forum

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.

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!!

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 anoth...