I have a report that lets me enter a batch number, and outputs a corresponding order number. 

 

The batch number is really a lot number, and every time the material from that lot is used to prepare another mid-level assembly, an order number is assigned which becomes the lot number (or new batch number) for that mid-level assembly. 

 

The report is intended to work as a way to trace the original source material through multiple orders, incase there is ever a recall.

 

The report is not very efficient though, because one must enter the original batch/lot number, run the report, and get a list of all orders generated from that original batch.  Then, the user must run the report again, once for each order number in the first set of results, then again for each order in that set of results, and so on, untill a null value is reached, meaning the terminal use has been discovered, or the product is gone (in which case we would use another method to search for the sale).

 

My question is, is there a way I can build the result object "order number" into my queries record filter, so that I ask for all orders with the manually entered initial batch/lot number, and then have it automatically also run for for all corresponding order numbers?

 

I find this very confusing to talk about, hopefully you understand what I'm trying to say.  If not, I will be happy to elaborate.

 

Thanks,

 

Paul

 

BTW... here is my current Record Filter:

 

InStrRev({intrans.batchno},{?Source Batch}) = 1 and
{intrans.orderno} <> ""

 

note:  if the {intrans.orderno} is "", it is not a transaction type I'm interested in. 

 

 

The report currently delivers a result like this:

 

TranType   Part#   Qty   TranDate   BatchNo   OrderNo 

 

 

 

Not sure if that extra info is helpful, but thought it might help you visualize what I'm describing.

 

Thanks.