Hello all!
I'm trying to learn VBA and Access and to do so I'm in the process of developing a training management database.
The area I am currently working on relates to my tblTrainingCourses tblTrainingClasses. As you can imagine, each course can have many classes associated with it, moreover, each class has the potential to be cancelled and is part of a linear sequence of lessons. When a class is cancelled then the lesson number for the next lesson needs automatically adjusting, as per the example below.
tblTrainingClasses:
ClassID_PK | LessonNumber | LessonStatus (dropdown)
-------------------------------------------------------------------------------
1 | 1 | -
2 | 2 | -
3 | N/A | Cancelled
4 | 3 | -
My question is (as a noobie trying to learn): what is the best way to achieve this effect?
I would like to present the data so there is a tblTrainingCourses record form, with a Subform within that for tblTrainingClasses listing all of the lessons for that course that will update the LessonNumber for future lessons if a dropdown ("LessonStatus") is adjusted.
I'm not seeking the code itself, just hopefully some specific pointers on the best approach for me to research and explore.
Thanks in advance!
J
I'm trying to learn VBA and Access and to do so I'm in the process of developing a training management database.
The area I am currently working on relates to my tblTrainingCourses tblTrainingClasses. As you can imagine, each course can have many classes associated with it, moreover, each class has the potential to be cancelled and is part of a linear sequence of lessons. When a class is cancelled then the lesson number for the next lesson needs automatically adjusting, as per the example below.
tblTrainingClasses:
ClassID_PK | LessonNumber | LessonStatus (dropdown)
-------------------------------------------------------------------------------
1 | 1 | -
2 | 2 | -
3 | N/A | Cancelled
4 | 3 | -
My question is (as a noobie trying to learn): what is the best way to achieve this effect?
I would like to present the data so there is a tblTrainingCourses record form, with a Subform within that for tblTrainingClasses listing all of the lessons for that course that will update the LessonNumber for future lessons if a dropdown ("LessonStatus") is adjusted.
I'm not seeking the code itself, just hopefully some specific pointers on the best approach for me to research and explore.
Thanks in advance!
J