System command, dreport and data transfer

[Dan Snyder]

Hello everyone,

I have filePro v5.0.14 on LINUX.

I need help doing the following...
----------------------------------
1. Lookup a group of records in a file (file1-jobs).  This file could have
multiple records with the same part number.
2. For each unique part number in file1, lookup related records in another
file (file2-bill_of_materials).  File2 may have multiple records for each
part # which I would need to loop through. 
3. For each record found in file2, create new records in a third file
(file3-temp_working_file).  Multiple records will be created in file3 for
each record in file2.  File3 is used for "whatif" calculations and
reporting.


I tried the following...
------------------------
1. "D-Request Output" on file1, select the records I want (customer & date
range), using a report that subtotals by part number and calls the following
in the subtotal processing...

system "/appl/fp/dreport masterbom -f towhatif -v jobs_bom1sel -a -u -bg
-bs"<vr
vr contains the variables I need to pass to jobs_bom1sel to select the
records in file2

This works fine if I manually enter data from one record on the command line
or if I attach the code to a key in the input processing table.
Unfortunately I need to loop through a large # of records and the "system"
command doesn't appear to work in an output processing table.

2. I already had the "towhatif" processing only output that creates records
in file3 from data in file2.  This "towhatif" works fine if I call it from
within file2.  file3 has all the reports we need already setup.

Can anyone confirm that the system command does or doesn't work in output
processing?
Does anyone have a suggestion on how I could accomplish my objective listed
above?


Thank you,

Dan Snyder
IT Manager
Mercury Electronics
717-428-0222 ext.224