I am making a production tracking solution for my small business.
I have a table ORDERS as a parent and ORDER ITEMS as a child. Each ORDER has many ORDER ITEMS. When each order item is complete it is flagged "complete". Currently I have to go through and manually check to see when all the order items for a given order are complete. I would like to find a way to automatically mark the order complete when all the order items are.
Any help would be greatly appreciated !