Banging Head against the wall....
I have an InfoPath 2013 Form that customers request supplies from that saves to a SharePoint list.
The form has a repeating table that is linked to a secondary data source (SharePoint List) that contains an inventory of supplies
The customer selects a "Nomenclature" from a dropdown list (secondary data source) their selection inputs a default value of 3 repeating table fields (items ID #),(Cost), (UOM).
The customer then inputs the quantity they are requesting of that item.
When they submit the form it is sent for approval - once approved I would like to subtract the quantity requested of each Items ID# from the secondary data sources quantity on hand field.
Is this a rule I can add to the "Approved Button" if so a little guidance would be greatly appreciated, been working with so many formulas and rules that Im feeling stumped.
Thank you