With Cathy’s help I was able to pull in the Employee ID and Employee name onto the material tag. However, if the employee is logged into the same job more than once when he goes to print the material tag it prints out a tag for each operation that he is logged in to.
Does anyone have a suggestion as to how I can tie the Active transaction record to the corresponding grid row that the operator is selecting when he reports a quantity?
Thanks for your reply … just to confirm your statement on setting the links … are you referring to the relationship?
I have LaborDtl-EmpBasic
[/uploads/default/original/2X/9/9f0a4324739569ae829977376e4cf037f2ed5d7e.png]
From the EmpBasic, the links you are calling out are not available. What tables are you using when setting those links?
OK, I feel like I am coming into this with conversation half done. Sorry.
I can see the relationship link will not work with the tables you have. The employee table is the child table and the labor detail the parent, right? And you are using an inner join there?
The employee table is the child table and the labor detail the parent. I am using an inner join in Crystal. (EmployeeNum-EmpID)
I’ve tried several variations of joins and parent – child, with no success.
I feel it should be possible to achieve, but am missing some small, probably, easy fix.