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
|
|||
|
|||
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. |
#2
|
|||
|
|||
Training Database Help
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. |
#3
|
|||
|
|||
Training Database Help
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. |
#4
|
|||
|
|||
Training Database Help
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. |
Thread Tools | |
Display Modes | |
|
|