Material tags (MES)

Good morning all,

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?

Any help would be appreciated!!

Thanks
Carol

You will need to set the links for the job #, Assem# and oper seq #. Not just the job #.

Brad Boes
bradboes@boosterpconsulting.com
231-845-1090

Hi Brad,

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?

Thanks much!
Carol

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?

Which MES screen are you the printing tags from?

Brad Boes
bradboes@boosterpconsulting.com
231-845-1090

Brad,

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.

Thanks for any help.
Carol