Tables

[Guest]

I am trying to create a database with a list of qualifications for
instructors - each instructor can have numerous qualifications, and varying
levels of each qualification. I have the first table as the main table, do I
need to create different sub tables for each qualification with the various
levels listed, or can all the qualifications and the level of each be
included in one table. If so, how????? Any help could be greatly appreciated.

 

[Guest]

I would create a table of each unique qualification type
tblQualifications
=============
QualID autonumber primary key
QualTitle
Then create a table that relates these qualifications to instructors:
tblInstructorQuals
===============
InstQualID autonumber primary key
QualID links to tblQualifications.QualID
InstructorID links the the primary key of your instructor table
Level
There should be one record for each instructor for each of their quals in
tblInstructorQuals.

 

[Guest]

Thanks for that Duane, however can you please clarify:
should the level of qualification achieved be listed in the table with the
qualification name? If so, the tables with individual qualification only
lists the title of qualification and the id number of that particular
qualification. Would the various levels of qualifications be listed under
the instructor qualification table?
Therefore, the instructor table listing personal details would be the parent
table, then the instructor qualifications table would be a subtable of that,
and then each individual qualification would be a sub table within that....

Sorry - I am pretty confused at this point, I have a book on access but it
doesnt seem to go into much details. your help is greatly appreciated.

 

[Steve]

TblInstructor
InstructorID
Firstname
LastName
....

TblInstructorQualification
InstructorQualification
InstructorID
QualificationID
QualificationLevelID


TblQualification
QualificationID
Qualification

TblQualificationLevel
QualificationLevelID
QualificationID
QualificationLevel



PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Guest]

I never really think about "subtables". It looks like Steve's reply and mine
are fairly similar. We both had the level in a table that is a "junction"
table between your instructors table and your qualifications table.

Steve correctly created a "lookup" table for qualification levels.

 

[Steve]

Duane,

I take your reply as a compliment. Thank you!!

Steve

 

[Guest]

Yes, definitely a compliment.