Hi Jason ---
Is jurisdictionid (the rowsource field) numeric? Is the controlsource field numeric? I don't feel like I've got all of the information here to make a call.
You said you had BoundTo and BoundColumn set the right way (.t., and 2).
>
>njurisdictionid is the field in question.
>
>I created a combo box for this field on my form, "county_assignments.scx".
>The combo box is using a view I created to call up the needed information. So, my combo box might look like:
>
>FLORIDA 1
>ALABAMA 2
>GEORGIA 3
>
>The state name is jurisdiction name and the number is jurisdiction id
>
>In the value tab of the combo box it asks me which I want to save. I choose jurisdiction name, so that the name FLORIDA appears in the box on the form when I select it. Everything so far works perfect.
>
>The problem comes when I go to the table (county_assignments.scx, where this data is being stored). I see the number 1, instead of FLORIDA in the table. I would like to have FLORIDA saved in the table and not the numeric number. The problem is that the table field is a numeric data type.
>
>In Access, this isn't a problem for me b/c I can create a "lookup" in the table for the particular field, which may be an integer field, and have a character string placed back into it.
>
>I just don't know how to do that in Fox.
>
>TIA
>
>Jason
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05