How do I Link Job Header to part Tran Table in Epicor Database

[rahul.sharma]

Hi Guys,

Could anyone please advise how to link the Job Header to Part Tran Table and all Job Tables Linkages.

I am trying to calculate the WIP.

Thank in advance

Rahul

[timshuwy (Tim Shoemaker)]

there is a job number field in both tables. you simply put both tables into a BAQ, and they will auto connect.

[rahul.sharma]

Hi Tim,

Thanks for your reply. I am trying to create a Power BI Data Model and not a BAQ.

So I do need a key.

regards,
Rahul