Above are 4 pictures of what I am experiencing. I had thought I had established a correct parent/child relationship. I have data in Work Order table "Status". I want that data showing up in Shop Labour. I also have a specific filter that states that to not show results if the work order status is "complete" or "cancelled."
As you can see in the bottom image, I am getting data from a work order (3225) that is marked "complete" and also the Work Order - "Status" column is blank.
