Bah. I know how that is. . .
OK, since you're probably going to want to store the Job and Purchase Order numbers separately, I'd recommend keeping them in two separate fields like this:
Purchase Orders Table
Code:
PurchaseID|JobID|Other Fields. . .
1001|100|. . .
1002|102|. . .
1003|101|. . .
1004|102|. . .
Jobs Table
Code:
JobID|Other Fields. . .
100|. . .
101|. . .
102|. . .
Then, in your report, you just make an Unbound Text Box and use the following Formula in it:
Code:
=[JobID] & "-" & [ProductID]
What that code does is take your JobID and ProductID fields (both from the Purchase Orders Table) and sticks 'em together with a dash in between.
Therefore, the four Purchase Orders listed in the Table above would be printed out as:
Code:
Purchase Order Number
100-1001
102-1002
101-1003
102-1004