Problem with Combo box in subform

G

Guest

I have a database to track all employee applicants. There are three tables.
tbl #1 "Employee Applicants" :
fields: (1) ApplicantID - Autonumber (2) Name - Text
tbl #2 "Job Skills Categories"
fields (1) SkillID - Autonimber (2) Skill description
tble #3 "Employee Job Skills" - junction table
fields (1) ApplicantID (2) SkillID

I have a form with the fields from the Employee Applicants table and a
subform based on a query of data from tbls "Employee Applicants" and "Job
Skills Category". The subform contains a combo field "Job Field Description"
with row source "Job Skills Category" with 2 columns (one for SkillID and one
for Skill description) bound to column 1. I have the column widths set so I
can see both the SkillID and the Skill Descrption.

The problem is that when I go to the main form and choose another skill from
the drop down menu in the subform, the SkillID displaysinstead of the Skill
Description. Also, it creates a record in the "Job Skills Category" table
instead of the "Employee Job Skills" table.

What am I doing wrong?
 
D

Duane Hookom

I think you want to bind your subform to table #3. This subform would have a
combo box with a row source based on table #2.
 
G

Guest

Thank you for your reply. I don't know how to bind my subform to table #3,
but the subform does have a combo box with a row source based on table #2.
What else can I check?
 
D

Duane Hookom

You stated:
subform based on a query of data from tbls "Employee Applicants" and "Job
Skills Category"

I think your subform should be based on table #3 not tables 1 and 2.
 
G

Guest

Okay. How do I get the Job Skill Description to show up in the drop down
combo box? Table #3 only has the Job SkillID and ApplicantID.
 
G

Guest

I've made some progress since your last repy. I based the subform on table
#3 as you suggested. Then in the combo box of the subquery, I indicated
column count = 2 with widths of .2";1" with bound colum #1. This works
great. I can see the skill description from the drop down box and it is
creating a record in table #3 as it should.

It would be better for me if I saw the job skill description instead of the
number after making my choice. How do I accomplish this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top