Formula to add records for any grandchild records that have checkbox and specific field value?
What I am needing to happen is for a user to be able to click a button on an "Orders" table and have an additional record added to the grandchild table for each grandchild record that has a checkbox checked and an "unfilled qty" > 0. I also need this same event to then un-check all of the checkboxes.
Is there any way to do this? '
Example:
Orders < Line Items < Shipment Detail #1: fill qty=3 unfilled qty=5 checkbox=true
new Shipment Detail : fill qty =5
Is there any way to do this? '
Example:
Orders < Line Items < Shipment Detail #1: fill qty=3 unfilled qty=5 checkbox=true
new Shipment Detail : fill qty =5
