Combo Box Query

[MAVIS]

I am trying to create a Database to record all the personnel in my Department. I have one table called ‘Staff ‘and in that table I have created one field with their individual names along with the 10 fields, each of which represent specific qualifications that that each post needs in order to do their respective jobs. On a form I have a Combo Box, which derives the specific qualification that they need via a separate table with the properties of :Row Source Type of ‘Table/Query’ and a Row Source of SELECT which points to the 2 fields within a separate qualifications table (Code & Qualification). How do I construct a query that looks at this qualification value and it’s associated code upon selection and then returns the name of a specific person from the ‘Staff’ table that requires that particular qualification when selected from this Combo Box. ACCESS databases are totally new to me and I am consequently at a loss as to how to ‘knock-up’ a specific query that is based upon the value that is returned via this Combo Box?? Any help is greatly appreciated.

 

[ColinEssex]

I have one table called ‘Staff ‘and in that table I have created one field with their individual names along with the 10 fields, each of which represent specific qualifications that that each post needs in order to do their respective jobs.

You need to think about your structure.

You need a table for staff demograhic data. Another for the posts and a third for the qualifications. Like this

tblStaff
txtStaffID (Autonumber) PK
txtForename
txtSurname
DteDOB
txtPostID (FK to tblPost)
etc

tblPosts
txtPostID (Autonumber) PK
txtPostDesc
etc

tblPostQual
txtQualID (Autonumber) PK
txtQualDesc
txtPostID (FK to tblPost)

Then you get one person in one post needing many qualifications. Do the links in the Relationships

Col