Hello,
I'm about to try and add a new function to a db I made but wondered if anyone had any top tips before I try and struggle myself!
db consists of many fields but one is a drop down menu from which the user can select various training courses.
Some of the courses need to have an associated certificate consecutive number, we have to have these as AA001/2017, AA002/2017, etc. then reset back to 001 at the start of each year.
My problem that I'm thinking is that out of 25 courses only 4 need to have this and out of them 4 courses each one needs to have different letters/consecutive number, so it might look something like the below:
Course ConNumber
A AA001/2017
A AA002/2017
B BB001/2017
C CC001/2017
A AA003/2017
C CC002/2017
I'd like the consecutive numbers to be automatically generated depending on the course that is chosen.
I'm thinking along the lines of 4 update queries but then not too sure....
Any ideas?
I'm about to try and add a new function to a db I made but wondered if anyone had any top tips before I try and struggle myself!
db consists of many fields but one is a drop down menu from which the user can select various training courses.
Some of the courses need to have an associated certificate consecutive number, we have to have these as AA001/2017, AA002/2017, etc. then reset back to 001 at the start of each year.
My problem that I'm thinking is that out of 25 courses only 4 need to have this and out of them 4 courses each one needs to have different letters/consecutive number, so it might look something like the below:
Course ConNumber
A AA001/2017
A AA002/2017
B BB001/2017
C CC001/2017
A AA003/2017
C CC002/2017
I'd like the consecutive numbers to be automatically generated depending on the course that is chosen.
I'm thinking along the lines of 4 update queries but then not too sure....
Any ideas?