I have Purchase form which has a Purchase-Item subform.

after the purchase Is made, the manufacturing process begins and i subtract from stock the needed items to make the desired purchase item. to keep track of the stock movement, i create on validation a purchase item of the needed component where i record a timestamp and the stock level at that point. this way, the report showing Purchase-Items can show me stock movement of different items over time.

i would like to connect the needed component Purchase-Item to the Purchase record. when i do, i see another row on the subform of purchase items. since this is only to keep track of stock, i dont want it on the purchase items subform (which is connected to PDF's and invoices etc).

so...

can i create another subform of purchase-item in Purchase and connect the needed item to that specific subform?

it must be done via "insert record" and not "add row" since i have static forms inserting purchases and other processes changing stock.

thank you