I have 2 tables:
Table 1 = Position Names
PositionID - Data Type = AutoNumber
Position Name - Data Type = Text
Table 2 = Staff Positions
StaffID - Data Type = AutoNumber
Last Name - Data Type = Text
First Name - Data Type = Text
Position Name - Data Type = Number, Display Control = Combo Box...
It IS a good practice when you are creating a database that has these tables:
Staff Names
Positions Names
Training Courses
Position Course Requirements
Staff Courses Completed
so that you can created a query to show you what courses staff have not taken in order to be qualified for your...
Right now I have a table with first and last names of customers as separate
fields.
I have a few other tables with their first name, last name, and other
fields. These tables have to remain separate for some queries I am running.
How do I link the First Name and Last Name...
I am trying to set up a staff training database that will help figure out what trainings they still need to take for their positions.
Here are the mock tables and fields I have set up.
Table 1:
Position Name
Required Training 1
Required Training 2
Required Training 3
Required Training 4...