Subtotals of items in portal
I have a record that I add items to the portal via script. Food, Bev, and Other. The portals to the right isolate the items in the menu table by these categories. My problem comes from subtotaling the items in the portal. The top screen shows the portal with some records. The bottom screen shows the subtotal I have collected.
My relationship seems correct, for what I know. But everything totals into the FOOD_Subtotal field. That will affect the taxes calculated as well as revenue coding.