Hello all,
I'm a little new to VBA and Access but I'm taking on a project to try and learn both and I'm hoping to get some pointers on a problem I've been working from the guys and gals here
My project is a database system to handle training programs. I have a concept (table) of Training Classes that are associated with a table for Courses. Each course will have many classes and it is common for a class to be cancelled, in such a situation the lesson number for future classes needs updating accordingly.
For example:
Course 1
- Class 1
- Class 2
- Class 3
- Class 4
If a status field in a class record were to be changed to 'cancelled' then the class sequence would change for the class number in future records in the sequence of classes:
Course 1
- Class 1
- Class 2 (cancelled)
- Class 2
- Class 3
I'm wondering if anyone can recommend the best approach to achieve this outcome? I'm looking to learn so ideally looking for pointers on the VBA or Access functionality to research please.
Thanks in advance!
Jez