Solved: Add multiple rows to child table when a parent tab... - Page 2

Rifad · 11-12-2020 06:45 AM

Hello

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!

Koichi_Tsuji

I m not entirely sure what your requirement will be, but it seems you have three schema ; -

Order Table - grand parent
Product - Parent
Steps - Child

Upon adding new row to Product, then fire the actions Steve introduced. Once new product is added to Product table which is under the Order table, then steps (set of row associated to each product) will be automatically added to step table.

This is all what I can comment to you

View solution in original post

Add multiple rows to child table when a parent table is updated