I'm starting with a number 5500
I have a field named "Prev_ADSK" If that value is True
I would like to have that number placed it in field "EMP_ID" in another table.
Example: if a project has 10 employees. And 5 of them have a true value in "Prev_ADSK" (text field).
The number 5500 would be placed in the first employee record in field "EMP_ID". The second employee with true in "Prev_ADSK" would get the next number 5499 and the next employee would get 5498 and so on. Once all of the True "Prev_ADSK" fields have been placed. I would like to subtract 3 additional numbers from the final number.
Example: If the last number is 5490. I would like to subtract 3 numbers from that number in case we hire 1-3 more employees and need those numbers for the new employees at a later date.
How would I start this procedure? Do I have another table that list the numbers?