I have a form “Add Item” (Screenshot attached).

I have another form “Purchase Order” which has a subform “Item Details”.

 “Item code” is a lookup field of “Add Item” form’s “Product code” field

We need that when the product code is selected, the code should add the records of “Diamond details” subform from “Add Items” form to “Purchase Order” form.

For each item added in the “Purchase Order” form, there should be a new table added to “Purchase Order” with “Diamond details” records from “Add Items” form.

Also when the”diamond details” subform records are added to the “purchase order” form, the code should add 2 more fields “price per carat” and “total”.

I have attached the “Add Item” form’s fields in a separate PDF.

Please let me know how to achieve this.