Link Sales Order and Job details

[Sherlin (Sherlin Susanna Shaji)]

Hi,
I’m trying to link the OrderHed table to their jobnumbers. Can you please guide on how to achieve this ? I need the job number and description.

Thanks

[Adrian_Mepham]

This is how I would do it;

[alex.ball]

I would also include the OrderRel table.

[Sherlin (Sherlin Susanna Shaji)]

Thank you @alex.ball and @Adrian_Mepham for the quick reply.

[utaylor (Utah Taylor)]

I would also include orderrel table.