I am trying to edit my autoprint PartTran STK-MTL label to include the Project ID. I get the Project ID by adding the JobHead table to the existing ones in the group: Company, Part, and PartTran.
If I write a simple SQL query and join PartTran to JobHead I can pick up the ProjectID for each PartTran, if there is any.
However, if I add JobHead to the Report Data Definition I just get blanks. In the .BT file I do see the headers from the JobHead fields I added. I have the following (default) Relationship Fields between PartTran and JobHead: Company & JobNum. The type is Definition Only.
What am I overlooking here?