Here are a couple of options.
- Set up a self join based on Job# and Count the number of records. Add 1 to the Count value when you create the the next record. This could be set up as an auto-enter calc with Do Not replace Value.
- Script this and have the script do a find based on Job#. Set Variable to the Value of Get(FoundCount) and add 1. Then create the new record and Set field
- Do a Find based on Job#, sort decending by emp@job, go to record 1, set Variable to emp@job + 1, create new record and set field.