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 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.
"KARL DEWEY" wrote:
> 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.
>
> --
> Build a little, test a little.
>
>
> "PlarfySoober" wrote:
>
> > 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" wrote:
> >
> > > Post the field names and datatype from bothe tables. Post sample data from
> > > both tables.
> > > --
> > > Build a little, test a little.
> > >
> > >
> > > "PlarfySoober" wrote:
> > >
> > > > 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" wrote:
> > > >
> > > > > Does your 'Job Titles' table have a primay key field and does the datatype
> > > > > match the field in the Applicant table?
> > > > >
> > > > > --
> > > > > Build a little, test a little.
> > > > >
> > > > >
> > > > > "PlarfySoober" wrote:
> > > > >
> > > > > > 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.
> > > > > >
Similar Threads
