Related tables limited data

Hello All,

I am hitting a wall on what should be a simple task.
I have two tables called "Orders" and "Rejected Orders" with a relationship between the Order_Number field that is in both.

When I add field from the order table to a table visual all the orders and there assocciated data is displayed.

Hoever if I add a field from the related "Rejected Orders" table, such as who rejected it, the resalts in the visual are only orders that have been rejected.

The goal is to show all orders and if there is a rejected order to show its values in otherwise it should be blank.

I have tested with changing the cross-filter but that did not seem to help.

What am I missing?

Thanks

Chuck