Database help required

[JPRENG]

I have set my database up as follows, and would just like some adive before I proceed with it.

tblEmployee
Employee ID
Surname
Forename
Grade

tblQualification
ID
Qualification

Now I want a form that shows the Employee Details, but I then want to be able to select (multpiple) qualifications that an employee has. I tried doing a subform but the user had to manualy enter each qualification into th subform, I was hoping for a lookup box so the user could just select the qualification.

If anyone has any suggestions on how I could do this (maybe theirs an easier way than subforms?) Please help me. Thanks.

 

[Mihail]

tblEmployes
ID_Employee (PK - AutoNumber)
Surname (Text)
Forename (Text)
ID_Qualification (FK - Number, Long - Lookup on tblQualifications
Grade (TypeOfData)

tblQualifications
ID_Qualification (PK - AutoNumber)
Qualification (Text)

 

[JPRENG]

tblEmployes
ID_Employee (PK - AutoNumber)
Surname (Text)
Forename (Text)
ID_Qualification (FK - Number, Long - Lookup on tblQualifications
Grade (TypeOfData)

tblQualifications
ID_Qualification (PK - AutoNumber)
Qualification (Text)

How would I create the lookup on the ID_Qualifications field?

 

[Mihail]

In the field data type (table design) choose the Lookup wizard.
All the experts will say that is not OK but for a very beginner I say that this approach is the best.

 

[JPRENG]

Will this allow for multiple Qualification selections?