Link IM Item Table to JC Job Transaction Detail Report Work Table?

SOLVED

Hello,

Has anyone found a way to link IM_Item Table to the JC Job Transaction Detail Report Work Table?

We are looking to get an item description included along with a part number on the report when we view for material pricing purpose.

I am sure that it might take several jumps with UDFs between tables, but I cannot seem to find a path to get IM Item associated with the Job Trans Detail Report Wrk table.

Any help would be appreciated.

Thanks,

Jacob