How to Join SOOrder to SOShipment in Report Designer to Display Contact Information on Delivery Note (SO642000)

Hello!

The SOShipment needs to be tied to the SOShipLine table.  The SOShipmentLine table has the sales order number available.  

The shipment header can technically have more than one sales order reflected, so it is the line level that has the link to the sales order number.

I hope that helps!

Kathy

​@kmuczynski54 
Hello and thank you for your help!

That makes sense and I was able to join the tables successfully.

However, I actually need to display the first name and last name of the customer contact separately (not the full ContactID description).

Currently, when I use the ContactID description field from SOOrder, it shows something like:
 

KopierenBearbeiten

LastName FirstName; Title

But I would like to display just:
 

KopierenBearbeiten

FirstName LastName

Is there a way to access the FirstName and LastName fields directly from the related contact record (Customer Contact)?

Thank you again for your support!

Best regards,
Pantea

​@lauraj46 
Hello and thank you for your help!