Hi Gang!

Weird problem here I came across and having a bit of a time trying to figure it out....

I have a form with a combobox which pulls from a table called ECL. The comboBox has a table called PM as its CONTROLSOURCE.

PM has one field - SC which is Numeric of 1, 0

Now..... the ComboBox is Bound to Column 2 of the SQL below....

The RowSource of the ComboBox is the 2nd column of the ECL table.... here is the code for the RowSource...
SELECT FLD_DESC, VAL(FLD_VALUE) AS SC FROM ECL WHERE FLD_NO = '305' AND FLD_NAME = 'C5' AND RANK > '1' INTO CURSOR CSRTOMMY ORDER BY FLD_VALUE

The RowSource Type is 3 - SQL.

and the 3 records that are exposed by the SQL are...

FLD_DESC FLD_VALUE

Not Specified 0

Male 1

Female 2

So... When I pick Not Specified, I was expecting 0 to be in PM.SC... but I get 1

When I pick Male, I expect 1, but I get 2

and when I pick Female, I expected 2, but I get 3.

Looks like I am getting the Record Number of the csrTommy. What am I obviously overlooking?

Thanks!!