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 !
Count ( LineItems::primaryKey ) = Count ( LineItems::completionFlag )
assuming that the field is empty until completion.
If that's not the case, and you are using different text flags, try
Count ( LineItems::primaryKey ) = ValueCount ( FilterValues ( List ( LineItems::status ) ; "complete" ) )