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?
The key fields are different/incompatible. What's your end goal?
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.
Really what I'm trying to get to is pulling contacts from the Job Contact List, but that's proving quite difficult.
*Community Hub is the new name for Sage City