 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / February 2005Setting Pre-requisites???
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. You need three tables. One for the people PeopleID Name Phone One for the courses CourseID CourseName Prerequisites One for the courses people took. Course-PeopleID CourseID PeopleID DateTaken DateCompleted Add a record to the Course-People table every time someone takes a course. Before that record is added to the Course-People table, make sure there is another record in the Course-People table showing that person completing the required Course(s). You would know what's required, because it would be listed in the Courses table for that CourseID. > 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. Hem13P, Take a look at www.newhorizons.com Register at our Integrated Learning Manager Its a free assessment tool that you can evaluate, manage, & track employees training. By having them take some of the assessments you can determine which courses would best benifit there developement. If you have any questions you can email me at cragsdale@nhdallas.com > 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.