I have this routine for moving data through this inventory program and it works great, however the customer would like to see 1 set or (Module) worth of reports that will work off cumulative numbers and print out averages of data therein. The problem with this is how the program was designed for data transfer.

What I am trying to accomplish is this that the data still moves on to the next stage but that the data is also stored elsewhere for later reports or ??? below is the code for moving the data, maybe it can be stored in a view or ??? I have not done this before.

Here's the code I am now working with

scatter name oRecord MEMO FIELDS EXCEPT lot,location,location2
insert into veg from name oRecord 
delete

Anyone have any ideas???

Thanks,

Fred W.