query 2nd column of combo box

  • Thread starter Thread starter Mike D.
  • Start date Start date
M

Mike D.

OK, I'm still having a problem with the following -

My MAIN TABLE has the following field -
Field Name - OPERATOR1
Display Control - Combo Box
Row Source Type - Table/Query
Row Source - EMPLOYEES
Bound Column - 1
Column Count - 2

My EMPLOYEES table has the following records entered -
OPERATOR SHIFT
John Doe 1st shift
Jane Fisher 2nd shift
Jack Baker 1st shift

When doing a query from MAIN TABLE and Field as
OPERATOR1, I can have "Jack Baker" as my criteria and get
the 1 record result as expected.

My problem is that I now want to return all results of
people on 1st shift.
I've tried having the field set as "[OPERATOR1].column
(2)" and the table as MAIN TABLE with criteria as "1st
shift".
I can't seem to get it to work right. What am I missing
here?


Thanks for your help.
Mike D.
 
I have looked at the replies to my previous post, but
believe that my question was misinterpreted. So, I have
posted this new question with more info. My field
results don't actually have a "|", that was to signify a
spearate column.

Your help is appreciated for the below question.
Mike D.
-----Original Message-----
Did you review the replies to your previous posts prior to posting this?

Mike D. said:
OK, I'm still having a problem with the following -

My MAIN TABLE has the following field -
Field Name - OPERATOR1
Display Control - Combo Box
Row Source Type - Table/Query
Row Source - EMPLOYEES
Bound Column - 1
Column Count - 2

My EMPLOYEES table has the following records entered -
OPERATOR SHIFT
John Doe 1st shift
Jane Fisher 2nd shift
Jack Baker 1st shift

When doing a query from MAIN TABLE and Field as
OPERATOR1, I can have "Jack Baker" as my criteria and get
the 1 record result as expected.

My problem is that I now want to return all results of
people on 1st shift.
I've tried having the field set as "[OPERATOR1].column
(2)" and the table as MAIN TABLE with criteria as "1st
shift".
I can't seem to get it to work right. What am I missing
here?


Thanks for your help.
Mike D.
Click to expand...


.
Click to expand...
 
Select * from EMPLOYEES WHERE Shift = "1st Shift"

Mike D. said:
I have looked at the replies to my previous post, but
believe that my question was misinterpreted. So, I have
posted this new question with more info. My field
results don't actually have a "|", that was to signify a
spearate column.

Your help is appreciated for the below question.
Mike D.
-----Original Message-----
Did you review the replies to your previous posts prior to posting this?

Mike D. said:
OK, I'm still having a problem with the following -

My MAIN TABLE has the following field -
Field Name - OPERATOR1
Display Control - Combo Box
Row Source Type - Table/Query
Row Source - EMPLOYEES
Bound Column - 1
Column Count - 2

My EMPLOYEES table has the following records entered -
OPERATOR SHIFT
John Doe 1st shift
Jane Fisher 2nd shift
Jack Baker 1st shift

When doing a query from MAIN TABLE and Field as
OPERATOR1, I can have "Jack Baker" as my criteria and get
the 1 record result as expected.

My problem is that I now want to return all results of
people on 1st shift.
I've tried having the field set as "[OPERATOR1].column
(2)" and the table as MAIN TABLE with criteria as "1st
shift".
I can't seem to get it to work right. What am I missing
here?


Thanks for your help.
Mike D.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top