Thanks. So I got the affected user to login to a different machine and it seemed to work fine.
I then back to the original machine and delete the cookies and cached data. I am monitoring it, I think it is working. I will update you guys later.
How to calculate JobID ?
- I use rollup in Maxjob column to give me the highest job number already used from IDsequence (see below on explanation)
- I then calculate NextJob = MaxJob + 1
---- this was then used as jobID at time of creating the job BUT, there was risk of duplicates if two people opened up the form at the same time, then both will get the same JobID---- - lkupem is the employee ID given at user creation this is unique for each user
- concatNextJob = emplyeeID and NextJobID this way two different users pulling the same ID will generate a unique ID (it will no longer be incremental but it will be unique)
- That new JobID is inserted into the JobID field
- Next I need to figure out what the sequenceID is (the incrementer before I did the concat join of employeeID and MaxJob (calculation shown)
- This sequenceID is then used to tell me what is the highest sequence used by becoming the input into the rollup column to start the cycle again
