Sounds like you need to create a Primary Key(Job Code).
Use Auto-Enter option with using Calculation for this. Thats the easiest way to solve!!
Yes the job code would be the primary key. When I tried using the AutoEnter option along with what I have I have in my calculation field , it removed the date and the year so the Jobe code was just 001. Is there anyway to appended the serial number to what I already have in my calculation field?
Thank you for your help.
Case ( CM <> "" and CY <> "" ;
SerialIncrement ( Max ( related::job Code ) ; 1 )
relation using CM and CY
I suggest you check the field type. It is possible that if you set it to autoenter a calc (currentMonth/currentYear/serial) but have the field type set to number, that only the serial is being recognised. The same may happen if you had a calc field with the calc result set to number.
Another trying worth mentioning is that using a MEANINGFUL job code as your primary key you are breaking the well established rule NOT to do this.