I'm having trouble joining the JC Job Master file with the PJ Job master file. This seems like it would be straightforward joining "JOB" ON "JNUM" but it's not working. Any ideas?
You would need to match the Job Index in PJ to the JNUM in JC. I did this by using a query That took the JNUM and use that to find JOB Index in PJ.
You would need to match the Job Index in PJ to the JNUM in JC. I did this by using a query That took the JNUM and use that to find JOB Index in PJ.
*Community Hub is the new name for Sage City