If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Employee Training Help
Hey Y'all,
I am creating an employee training database where I can run reports and queries about who has taken what type of course. What kind of relationship should be created between the tables? Based on the some of the discussions I have seen here, I have created three tables: 1: tblemployee (with employee id set as primary key) 2: tbltraining (with trainingid set as primary key).This table has no employee information 3: tlbcompletedtraining (in this table I have employee ids with the id's of the training courses that they have completed) I am unsure of what kind what kind of relationships to create between the three tables. Any help out there would be greatly appreciated.... |
#2
|
|||
|
|||
Employee Training Help
Lkay107 wrote:
Hey Y'all, I am creating an employee training database where I can run reports and queries about who has taken what type of course. What kind of relationship should be created between the tables? Based on the some of the discussions I have seen here, I have created three tables: 1: tblemployee (with employee id set as primary key) 2: tbltraining (with trainingid set as primary key).This table has no employee information 3: tlbcompletedtraining (in this table I have employee ids with the id's of the training courses that they have completed) I am unsure of what kind what kind of relationships to create between the three tables. Any help out there would be greatly appreciated.... Employee---(1,M)---SessionRoster---(M,1)---Session---(M,1)----TrainingCourse SessionRoster has "Grade" or "Completed" or something... to show that the "student" finished the course. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/201005/1 |
Thread Tools | |
Display Modes | |
|
|