B
BYoung via AccessMonster.com
I am developing a training database that keeps track of when an employee
completes different training course. I have 2 tables for the records.
tblTrainingTopic
idsTrainingTopicID
chrTrainingTopic
blnTrainingRequired
tblTrainingRecords
idsTrainingRecordID
chrEmpID (FK to Employee Information Table)
chrTrainingTopic (lookup list from tblTrainingTopic)
dtmTraining Date
chrTrainingFrequency (annual, new hire, accident)
memNotes
I have a tabular form that shows all training completed by an employee and
allows you to add new training records, but I would also like to create a
form that shows all the training topics in tblTrainingTopic and the latest
record for that particular training topic for whichever employee is being
viewed by the form. I want the training topic to be visible regardless of if
there is a record tied to that employee and training topic or not. Each
employee could have several records for the same course because many are
taken annually, but I want this form to only view the latest completion date.
Then I plan on adding a " View All Training" button that will open the
tabular form mentioned above.
Is there a way to create the form that I'm asking about?
completes different training course. I have 2 tables for the records.
tblTrainingTopic
idsTrainingTopicID
chrTrainingTopic
blnTrainingRequired
tblTrainingRecords
idsTrainingRecordID
chrEmpID (FK to Employee Information Table)
chrTrainingTopic (lookup list from tblTrainingTopic)
dtmTraining Date
chrTrainingFrequency (annual, new hire, accident)
memNotes
I have a tabular form that shows all training completed by an employee and
allows you to add new training records, but I would also like to create a
form that shows all the training topics in tblTrainingTopic and the latest
record for that particular training topic for whichever employee is being
viewed by the form. I want the training topic to be visible regardless of if
there is a record tied to that employee and training topic or not. Each
employee could have several records for the same course because many are
taken annually, but I want this form to only view the latest completion date.
Then I plan on adding a " View All Training" button that will open the
tabular form mentioned above.
Is there a way to create the form that I'm asking about?