I have a table where it stores Process.
The Process has each processNumber which is unique,
& the processNumber indicates the step of a procedure.
My problem is, user request to add a Process in between existing processes.
In other word the new Process overwrite the existing process number, & the others existing need to be updated to processnumber+1
What is the best way to do this in VBA access?, if you get what i'm saying