Combo Box Won't Permit Choice

[PlarfySoober]

I have an Applicant table. I created an input form, probably an arrogant
idea, but anyway, I have one field that I created a combo box for input, for.

The data comes from a separate table, Job Titles. The tables are
interdependent. When I try to choose some titles from Job Titles, whether in
the input form or in the Applicant table itself in input mode, it won't
accept the input and mostly goes back to a single title, Claims Coordinator.

Some titles are accepted, some not. Some go to other titles, but invariably,
most go to Claims Coordinator, for a reason I can't see.

If anyone can suggest anything about the process I've started, please feel
free.

Thanks in advance.

Don.

 

[KARL DEWEY]

Does your 'Job Titles' table have a primay key field and does the datatype
match the field in the Applicant table?

 

[PlarfySoober]

Karl,

Thanks for replying.

It has a primary key, and the primary key field <Badge>in Job Titles is
text, while the RecruitingApplicants table's combo box field <Position
Applied For> type is numbers. How THAT happened, I'm afraid I can't answer,
because it uses the contents of the Job Titles' <Job Titles> field, which is
also text.

Tried to change it in RecruitingApplicants table , and found I would have to
first delete the relationship, leading I'm sure to all sorts of complications
and drama.

Don.

 

[PlarfySoober]

Karl,

Thanks again. So, given that I have a primary key and it is NOT the same
data type as the combobox; and the combobox somehow has become a number
field; do you have a suggestion for sorting this out?

Trying to change the combobox field back to text resulted, as I said, in a
condition I probably don't understand and didn't look like progress to me.
Unless it's OK to change the data type, keep the data, and everything will be
hunky-dory. I don't know.

Don.

 

[KARL DEWEY]

Post the field names and datatype from bothe tables. Post sample data from
both tables.

 

[PlarfySoober]

Karl,

Thanks for following up. I regret I have gotten both of us so deeply into
this issue. However, your kind offer to look over what I have done may not be
fulfilled if I can't figure out how to "package" the field names. Let's see.

Nope. Tried exporting to a second file, the entire .mdb, but can't see how
to include it here. I apologize.

Don.

 

[KARL DEWEY]

Open table in datasheet view and click on the left marging of first record,
copy, and paste in a post. The field names and that record will be pasted.

 

[PlarfySoober]

Karl,

OK, thanks for the direction. Here it is:

Badge PositionAppliedFor Last Name First
Name ReceivedDate InterviewDate Email Address City Postal Code Home
Phone Work Phone Fax
Number SourceName ResumeHighlights GradeResume GradeEducation GradeExperience GradeResidence GradeReliability GradeImpression Explanation CommunicatedInterest CommunicatedRejection PhoneNotes
achau 7 Chau Anna 1/5/2010 1/7/2010 (e-mail address removed) Westminster 92683 714-360-7233 CSULB
EDUCATION Cal State University, BS Health Care Administration
Expected Graduation: Long Beach BA Economics December
2009 5 9 4 7 5 7 "Great education, not much work experience.

And the other table:

JobTitle Level Manager
Medical Director 01

Experience in communication with students, others." 1/5/2010 "1/5/10
Received phone call. 714-360-7233
1/5/10 Received phone call: Made appt. 1/6/10"


This doesn't come out with very deluxe formatting, but I suppose you have
done this before, and can sort it out.

I very much appreciate your efforts to help me with this. Looking forward to
hearing from you again.

Don.