I'm not sure where to begin with this .... I am using Access 2003 and I am building a database for multiple end users. The database contains records of how to perform processes in the shop where I work.
Each process will have multiple steps and each step can have multiple elements.
My process table contains multiple processes with sequential steps and my element table also contains multiple elements for each step.
When an end user needs to edit / insert / delete one of these steps or elements I need access to renumber them. For example: Process has 10 steps, step 5 is no longer necessary, so it will be deleted and I need to re-number the remaining steps from 1 to 9. Also, a process has 8 steps, and a new one needs to be inserted between steps 6 and 7 - I need to renumber from 1 - 9. I cannot use the auto number field in either case but I need to be able to ensure that the processes and elements are sequential to what the end user requests. Can anyone point me in the right direction to begin to come up with some way to handle this problem?
Each process will have multiple steps and each step can have multiple elements.
My process table contains multiple processes with sequential steps and my element table also contains multiple elements for each step.
When an end user needs to edit / insert / delete one of these steps or elements I need access to renumber them. For example: Process has 10 steps, step 5 is no longer necessary, so it will be deleted and I need to re-number the remaining steps from 1 to 9. Also, a process has 8 steps, and a new one needs to be inserted between steps 6 and 7 - I need to renumber from 1 - 9. I cannot use the auto number field in either case but I need to be able to ensure that the processes and elements are sequential to what the end user requests. Can anyone point me in the right direction to begin to come up with some way to handle this problem?
