Windows 10 
Office 365
Hello,
I am creating a Training Database at work. The work that we are tracking with this database is the training that we perform. We want to keep track of the students (in this case employees) by there ID# with first and last name, the name of the class they took, the instructor who taught them and of course the date. However I am having an issue with creating a data entry form for this database that will allow the user to add multiple employees with multiple classes. What I mean by that is that the employee took multiple classes on that particular day. I would then of course need to create reports from the entered data. But this is the form thread and I will need to save that. I will type out my tables with primary keys.
PKClassroom ID
Name of Class
Description
PKEmployee ID
First Name
Last Name
PKInstructor ID
Instructor Name
PKID
Employee ID
Classroom ID
Instructor ID
Class Date
The last table is the main table that we will be able to grab all of our report information from with the other tables as reference tables. I want the form to add the employee id and name into the table for that, however all the multiple employee id numbers would be on the last table mentioned. I should say that I am brand new at this and have read quite a bit and watched videos until my eyes bled. I have so much to learn. However I am under a time constraint. Any and all help would be appreciated.
Reply With Quote
