Good day all.
It's been about 18 years since I have seriously worked in Access, so thanks in advance.
I am the Training Chief for a federal fire department and I am creating a database to better track our firefighters certifications.
I have a table with our personnel in it that lists out their employee IDs (ESAMS ID) and I use that as the primary key across several tables. Those are CPR certification, EMTcertification (of which there are two types State and National), and their emergency vehicle driving certifications.
All have differing expiration dates and time periods.
Is splitting these tables the best practice? I felt it was but…
I wanted to create a form to enter new employees that wouldallow me to enter data across as many of the tables as possible at onetime. The problem I ran into was that Iwould have to type the ESAMS ID up to five times.
What I would like is to type the ESAMS ID one time and haveit create a record in all five tables. Is this possible?
I have attached a screenshot of the relationships of thetables in question.
Thanks Again,
Greg