I'm currently building a database to track employees that have been trained on certain test procedures. So that I can track who has been qualified to perform certain test. I have created three tables. They are, Table of Technicians, Table of Test Methods, and Table of Training Records.
tblTechnician – (EmployeeID is my primary key)
EmployeeID – AutoNumber
FirstName – txtbox
LastName– txtbox
JobTitle – txtbox
ShiftID – txtbox
ActiveEmployee - Yes/No
tblTestMethods – (TestMethodID and TestMethodRevision together makes my primary key)
TestMethodID – txtbox
TestMethodRevision – txtbox
TestMethodTitle – txtbox
tblTrainingRecords – (TrainingRecordID is my primary key)
TrainingRecordID - AutoNumber
EmployeeID – Lookup combo box from tblTechnician
TestMethodID – Lookup combo box from qryTestMethods
TrainingDate – Date/Time
I have also created two Queries. Query of Test Methods and Query of Training Records.
qryTestMethods
TestMethodID
TestMethodRevision
TestMethodTitle
This query was created to concatenate the two fields that make up my primary key from tblTestMethods (TestMethodID and TestMethodRevision). The concatenated field data is then used to populate the TestMehodID field in tblTrainingRecord as a look up combo box.
qryTrainingRecords
EmployeeID
LastName & FirstName - (concatenation from tblEmployees)
TestMethodID -
TrainingDate
JobTitle
Shift
I want to create a form based on my qryTrainingRecords. On the form I want to use a lookup combo box which filters the TestMethID. I would also like to add two additional command buttons. One that will allow me to preview the report before printing and one to print the report.
Your help would be greatly appreciated.
Thank you.
tblTechnician – (EmployeeID is my primary key)
EmployeeID – AutoNumber
FirstName – txtbox
LastName– txtbox
JobTitle – txtbox
ShiftID – txtbox
ActiveEmployee - Yes/No
tblTestMethods – (TestMethodID and TestMethodRevision together makes my primary key)
TestMethodID – txtbox
TestMethodRevision – txtbox
TestMethodTitle – txtbox
tblTrainingRecords – (TrainingRecordID is my primary key)
TrainingRecordID - AutoNumber
EmployeeID – Lookup combo box from tblTechnician
TestMethodID – Lookup combo box from qryTestMethods
TrainingDate – Date/Time
I have also created two Queries. Query of Test Methods and Query of Training Records.
qryTestMethods
TestMethodID
TestMethodRevision
TestMethodTitle
This query was created to concatenate the two fields that make up my primary key from tblTestMethods (TestMethodID and TestMethodRevision). The concatenated field data is then used to populate the TestMehodID field in tblTrainingRecord as a look up combo box.
qryTrainingRecords
EmployeeID
LastName & FirstName - (concatenation from tblEmployees)
TestMethodID -
TrainingDate
JobTitle
Shift
I want to create a form based on my qryTrainingRecords. On the form I want to use a lookup combo box which filters the TestMethID. I would also like to add two additional command buttons. One that will allow me to preview the report before printing and one to print the report.
Your help would be greatly appreciated.
Thank you.