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