This all works, and I save the generate lot number into the form on save.  I Started using a sub form to add ingredients into the product lot.  It works nicely.  

My problem is I'm trying to generate a report that mimics the input form.  I can generate a report using the BATCH form that shows the LOT# generating information, but can't display the ingredients nicely.  If I use the sub form INGREDIENTS I can list all the ingredients, but can't get access to the LOT # 's that generated the record. 

My goal is to display the following on the report.

1. LOT#
2.       Ingredient
3.       Ingredient
4.       Ingredient
5. LOT#
6.       Ingredient
7.       Ingredient
8. LOT#
9.       ...

I am able to do this if I don't use SUB FORM and the ingredient page links back to the LOT # but the input of the data is weird where on each ingredient line I have to select the LOT number each time....  I like the SUB FORM format.

Thanks

Andy