I’m trying to find a way to query what job number is user logged into and is active on the screen.
There is a table called LaborDtl. Find the rows where LaborDtl.ActiveTrans = 1 (true). Then return LaborDtl.JobNum. You can also see the assembly and operation. I believe that will give you those jobs that are punched into. You can join empbasic on labor dtl to get the full employee record (name, address, etc).
Nice, there is that too! Forgot about that one! @jgiese.wci
Thank you both, very helpful : )