I'm really getting into Query writing (6.0 going to 6.1 on 5/1). I
would like to be able to run a Query that is based on a Job Number.
Knowing that I am trying to relate an Open PO/Line/Release (for raw
material)with the opearation that requires it.
I can goto Job Tracker and change several screens to accomplish this,
but I cant seem to find the field code to tie it into a query. The
PO/Line/Release is obviously linked to the Job/Material
Seq/Opearation. (we link all of our material to the related ops)
I know the material status report also provides this infomation, I am
looking to manipulate the info a little differently than what is
canned.
Has anyone tried this or does anyone now the field relationship.
would like to be able to run a Query that is based on a Job Number.
Knowing that I am trying to relate an Open PO/Line/Release (for raw
material)with the opearation that requires it.
I can goto Job Tracker and change several screens to accomplish this,
but I cant seem to find the field code to tie it into a query. The
PO/Line/Release is obviously linked to the Job/Material
Seq/Opearation. (we link all of our material to the related ops)
I know the material status report also provides this infomation, I am
looking to manipulate the info a little differently than what is
canned.
Has anyone tried this or does anyone now the field relationship.