Training Database Help

I am in the process of preparing a Training file.

My Tables are

tbl EmpName (Containing)
EmpCode (Primary)
FirstName
LastName
Dept (lookup field) (Relationship 1 to Many from tbl Company Dept)
Active (Y/N field)

tbl Company Dept
DeptID (Primary)
Dept

tbl Training Attendees
TrainingID (lookup) (Primary) (Relationship 1 to Many from tbl Training)
EmpCode (lookup) (Primary) (Relationship 1 to Many from tbl EmpName)
AttendeeNotes

tbl Training Subject
TrainingSubjectID (Primary)
Training Subject
RecertificationRqd
WhenDue(Months)
Medical

tbl Training Provider
TrainingProviderID (Primary)
TrainingProvider
City
State
ContactFirstName
ContactLastName

tbl Training
TrainingID (Primary)
Training Subject ID (lookup) (Relationship 1 to Many from tbl Training
Subject)
DateofSerBeg
DateofSerEnd
Training Provider ID (lookup) (Relationship 1 to Many from tbl Training
Provider)
TrainingNotes

I'm not sure where to go next to make the tbl Training Attendees Many to
Many with tbl Training so that I can report who has attended a specific
training subject irrespective of the date they attended. I'm not sure where
to go from here. Any help would be appreciated.

In my opinion, it might be easier to just create a form to enter that data.
Create a table to store the data entered in the form. The data you would need
to enter would be an employee and a training session and date. Then any time
you needed that info, you could just query it off the table.

"RH" wrote:

I am in the process of preparing a Training file.

My Tables are

tbl EmpName (Containing)
EmpCode (Primary)
FirstName
LastName
Dept (lookup field) (Relationship 1 to Many from tbl Company Dept)
Active (Y/N field)

tbl Company Dept
DeptID (Primary)
Dept

tbl Training Attendees
TrainingID (lookup) (Primary) (Relationship 1 to Many from tbl Training)
EmpCode (lookup) (Primary) (Relationship 1 to Many from tbl EmpName)
AttendeeNotes

tbl Training Subject
TrainingSubjectID (Primary)
Training Subject
RecertificationRqd
WhenDue(Months)
Medical

tbl Training Provider
TrainingProviderID (Primary)
TrainingProvider
City
State
ContactFirstName
ContactLastName

tbl Training
TrainingID (Primary)
Training Subject ID (lookup) (Relationship 1 to Many from tbl Training
Subject)
DateofSerBeg
DateofSerEnd
Training Provider ID (lookup) (Relationship 1 to Many from tbl Training
Provider)
TrainingNotes

I'm not sure where to go next to make the tbl Training Attendees Many to
Many with tbl Training so that I can report who has attended a specific
training subject irrespective of the date they attended. I'm not sure where
to go from here. Any help would be appreciated.

The form I created to enter the data reflects a Training ID with many
Attendees. Can you provide help with creating the query to show all Training
by Attendee?

"Golfinray" wrote:

In my opinion, it might be easier to just create a form to enter that data.
Create a table to store the data entered in the form. The data you would need
to enter would be an employee and a training session and date. Then any time
you needed that info, you could just query it off the table.

"RH" wrote:

I am in the process of preparing a Training file.

My Tables are

tbl EmpName (Containing)
EmpCode (Primary)
FirstName
LastName
Dept (lookup field) (Relationship 1 to Many from tbl Company Dept)
Active (Y/N field)

tbl Company Dept
DeptID (Primary)
Dept

tbl Training Attendees
TrainingID (lookup) (Primary) (Relationship 1 to Many from tbl Training)
EmpCode (lookup) (Primary) (Relationship 1 to Many from tbl EmpName)
AttendeeNotes

tbl Training Subject
TrainingSubjectID (Primary)
Training Subject
RecertificationRqd
WhenDue(Months)
Medical

tbl Training Provider
TrainingProviderID (Primary)
TrainingProvider
City
State
ContactFirstName
ContactLastName

tbl Training
TrainingID (Primary)
Training Subject ID (lookup) (Relationship 1 to Many from tbl Training
Subject)
DateofSerBeg
DateofSerEnd
Training Provider ID (lookup) (Relationship 1 to Many from tbl Training
Provider)
TrainingNotes

I'm not sure where to go next to make the tbl Training Attendees Many to
Many with tbl Training so that I can report who has attended a specific
training subject irrespective of the date they attended. I'm not sure where
to go from here. Any help would be appreciated.

I am not sure which table is which in your case, but when you have a typical
training situation, there will be a many to many that you have to resolve.
This is the basic stuctu

Students - Those availabe to be trained
Subject - The course that will be taught
Session - A specific date, time, place the Subject will be taught
SessionAttendees - Here is where you tie them together. it should carry
primary key from Students and the primary key from session and the primary
key from Subject as a record. Something like
tblSessionAttendees
SaID - Primary Key
SubjectID - Foreigh key to Subject
SessionID - Foreighn key to Session
StudentID - Foreign key to Session (if you make this No Duplicates, you will
prevent a student being registered in the same session more than once)
--
Dave Hargis, Microsoft Access MVP


"RH" wrote:

The form I created to enter the data reflects a Training ID with many
Attendees. Can you provide help with creating the query to show all Training
by Attendee?

"Golfinray" wrote:

In my opinion, it might be easier to just create a form to enter that data.
Create a table to store the data entered in the form. The data you would need
to enter would be an employee and a training session and date. Then any time
you needed that info, you could just query it off the table.

"RH" wrote:

I am in the process of preparing a Training file.

My Tables are

tbl EmpName (Containing)
EmpCode (Primary)
FirstName
LastName
Dept (lookup field) (Relationship 1 to Many from tbl Company Dept)
Active (Y/N field)

tbl Company Dept
DeptID (Primary)
Dept

tbl Training Attendees
TrainingID (lookup) (Primary) (Relationship 1 to Many from tbl Training)
EmpCode (lookup) (Primary) (Relationship 1 to Many from tbl EmpName)
AttendeeNotes

tbl Training Subject
TrainingSubjectID (Primary)
Training Subject
RecertificationRqd
WhenDue(Months)
Medical

tbl Training Provider
TrainingProviderID (Primary)
TrainingProvider
City
State
ContactFirstName
ContactLastName

tbl Training
TrainingID (Primary)
Training Subject ID (lookup) (Relationship 1 to Many from tbl Training
Subject)
DateofSerBeg
DateofSerEnd
Training Provider ID (lookup) (Relationship 1 to Many from tbl Training
Provider)
TrainingNotes

I'm not sure where to go next to make the tbl Training Attendees Many to
Many with tbl Training so that I can report who has attended a specific
training subject irrespective of the date they attended. I'm not sure where
to go from here. Any help would be appreciated.