ChrisCalvert
Technical User
I am looking to have a list of employees and also a list of
required clases for those employees to take. What I want is to have the database set up in such way that it stores for each employee whether or not that employee has take each course. I have a table with name/extension/employee number. I was thinking about appending to that table boolean fields such as 'Class1' 'Class2', etc. I could just set up a 'training' tab, and some checkboxes on my form. However, I was thinking that there is probably some easier, better way to do this. Since I am not very experienced at creating databases, I thought I'd ask you all. I have other things for which I could use this type of tracking (to see which employees have what type of equipment assigned to them). I figure that putting all of the classes into a seperate table would be a good start but I am not really sure exactly how I would most efficiently make this show who had taken the courses. Suggestions appriciated...
-chris
required clases for those employees to take. What I want is to have the database set up in such way that it stores for each employee whether or not that employee has take each course. I have a table with name/extension/employee number. I was thinking about appending to that table boolean fields such as 'Class1' 'Class2', etc. I could just set up a 'training' tab, and some checkboxes on my form. However, I was thinking that there is probably some easier, better way to do this. Since I am not very experienced at creating databases, I thought I'd ask you all. I have other things for which I could use this type of tracking (to see which employees have what type of equipment assigned to them). I figure that putting all of the classes into a seperate table would be a good start but I am not really sure exactly how I would most efficiently make this show who had taken the courses. Suggestions appriciated...
-chris