Order Tables and MiscShip Tables

Hi All,

Has anyone linked these tables together? Epicor Consultant said it wasn’t possible.

Kind regards,
Aaron.

You should be able to join on MscShpHd.OrderNum = OrderHed.OrderNum
What does the report need to display?

I do not believe it’s that simple a lot of the order number information isn’t filled in… Just the job number which doesn’t match the job number on the order tables.

image

Nothing to join it to the order tables… I need to think of another way.

Wait are you trying to join JobNum’s ? the MscSHpHd has that field also.

MscShpHd.JobNum = JobHead.JobNum