Field Reset & Increment

[Bracon]

Hi All,



I have inherited a Change Request System that was created using Multiple Excel files (ughhh....). This system has grown out of control and is no longer manageable.
I need to keep a similar format to the previously used system parameters as not to duplicate previously used numbers, records, etc.. Also if possible I would like to import some or all of the previously used data. Secondly I want to keep a similar format as this will make transitioning easy for users.

I am looking for help and ideas on how to create a field that will Reset with a new record creation in one table and Increment by five.
Table MCR is where I keep project details, then I have a second TASK table where I would like a task number field to Reset to ten with every new MCR record, then increment by 5 for every new task record. Both tables will have an auto number PK that no one will see.

It would look something like this

Tbl_MCR -- PK 1 -- MCR_Nbr 100
Tbl_Task -- PK 1 -- Task_Nbr 10
Tbl_Task -- PK 2 -- Task_Nbr 15
Tbl_Task -- PK 3 -- Task_Nbr 20

Tbl_MCR -- PK 2 MCR_Nbr 101
Tbl_Task -- PK 4 -- Task_Nbr 10
Tbl_Task -- PK 5 -- Task_Nbr 15
Tbl_Task -- PK 6 -- Task_Nbr 20

Any and all ideas and solutions are appreciated

Thanks,

Bradley

[June7]

Generating custom unique identifiers is a common topic. Here is one for starters
https://www.accessforums.net/access/...ers-21361.html