You will probably want to look at a structure like:
Material Table Lot Sheet Table Transactions Table
Material ID --------< MaterialID TransactionID
Material Table will be the Ordered Material Details
LotSheet Table will be the record of each lot of material received
Transactions will be viewed through a portal to the Lot Sheet Table and list each "In" and "Out"
Now you can have summaries of how much is left of each lot, each material, how much out over the last year, etc...
Save to Pdf as appropriate...I just look at the dbase rather than a pdf.
Is this what you're after?
I created the tables and I think iv linked them correctly but I don't know how to link it with the data I want to be recorded...
It just says data unrelated on the layout and I don't know what to do...