Setting Pre-requisites???

H

Hem13P

I am creating a database to schedule training for a team of around 60 people.
There are also about 60 training courses, some of which are prerequisite to
others. I want to set up something which gives an error message if you
attempt to schedule training for an individual but they have not completed
all the prerequisites for this training. Haven't got the slightest on how to
start this!! Help please!! Any suggestiong aprreciated.
 
I

Impy

A long winded approach which may alos help in understanding Access, could be
as follows.
1) Create a table with the individuals listed within it- first name, last
name, location, grade, contact number...etc
2) Create a table with all your training courses in it and use the yes/no
option for a column called completed. This will allow you to 'tick' a course
as it is completed.
3) You will then need to write an 'if' statement which will basically say if
this is ticked - i.e completed, then they can have the next course.
 
Top