If you would be satisfied with a report link field on an order record to show an embedded report of the numbers fields on the order record, then you just need to get the [Record ID#] across to the numbers table.
So the Shipped table already has a field likely called [Related Order]. Look that up down to the Transactions table and call it [Record ID of Order]. Then do a Summary Maximum of that field up to the Numbers table. call it [Record ID of Order]
Then on the Orders table make a Report Link field called [Numbers report Link] On the left side use [Record ID#]. On the right, navigate back to your app and the numbers table and the field [Record ID of Order]. Then put that field on the Orders form and set the form to show the records on the form.