I am trying to figure out a way to add multiple rows in child table for the production steps related to this work order products. I have a table For products and products a have a child table for Multiple production steps attached to the products.
When i create a work order there is a child table attached to work order to add products related to that work order. What i want is… Whenever a new product is added to this child table of work order i want to add all the production steps related to the products in child table of work order into another table.
I tried many workaround and it is not working. I need to calculate the price, time etc… as per work order quantity. So the idea is to create child table record for production steps attached to work order ID whenever we create a new product inside work order.
It would be really great if i can find a way. Thank you everyone in advance!