cardinality is filtering data/ data disappear when setting relationship
I have 2 table. The main one contains location ID, Work Order ID (unique), Cost and the second one has Work order ID (multiple) and cost.
I want to display the total cost per Location ID.
Beacuse I am a beginner I am displayin the second table so to check what is happening and if I do not create any replationship it shoes correctly all the Work Orders ID and if I add a relationship (Work Order ID from table 1 and 2 ) the new table displays only few of them.