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?

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
--
Hansford D. Cornett


"Patty Stoddard" wrote:

> 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?