March 25, 200916 yr I'm not bad at FMP, but I created an invoice table that has "items" field that is related to a "items" field in a table called "Line items" that is related to the field "items" in an Inventory table. My question is how when I create records in my invoice portal showing "line items" to update my inventory as each line is created. There are some summary calculations missing here. I have something sort of working but the inventory does not update instantly with each portal record being created or deleted.
Create an account or sign in to comment