Display related record data in a form

[Guest]

I have a database to track all new employee applicants. My main table has
the applicant personal information with an autonumber as the key. I have a
second table with a list of job skills categories. My junction table has the
applicantID from the main table and a SkillID from the skills categories
table. I have created a query that combines the skillID with the Skill
description. I have a second query that combines those fields with the data
from the applicant table.

I have a form with all data from the applicant table and a subform based on
the second query with a combo box to add job skills. This is working
fine....but....I have to scroll though the subform to see which skills are
already assigned to the applicant. How can I view all skills related to the
applicant as a list?

 

[Guest]

Set your subform to Datasheet view. Or place a command button to make this
change only when you desire to see the list of records.

Dwgiht