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