Auto Update Quantities script
Im a relatively new user of FMP 11 on Mac OS X. ]
I'm trying to write a script that will automatically update the quantities in stock after an order has been placed. The order form creates line items in the Line Item table/layout and im trying to have the qauntities in the Products table ( joined to LineItems by the fields _kp_Itemnumber and _kf_itemnumber) be changed as soon as an order is marked as shipped. Any help would b appreciated.