I have added a new tab in a PRODUCTS Table..Data Entry Form View with a portal pointing to a newly created StockIN Table.
The user can create new STOCKIN records within this portal. please note that the STOCKIN Table is using the PRODUCTS ID to correctly relate, Identify the new records created.
In the PRODUCTS Table there is currently a Stock Counter which decreases in number when a line Item in INVOICES is committed.
Q. What script could be used to trigger the products counter button to update & or decrease in quantity as new entries are made in this portal which is in the Form view Layout in the PRODUCTS table .