I have an inventory app with tables order,orderitems (the line items),
products, locations, LocaitonProducts (This stores the inventory at each
location, products are often large enough to be in multiple locations)
the issue is when an order is finis...