Screech! I may have spoken too soon.

What data types don't match? Jurisid and njurisdictionid?


>
>That was a lame title, but it was all I could come up with!
>
>Here is my situation and resulting question>
>
>I have a table called "state_subor_assignment.dbf", which has three fields:
>
>A. nstate_subor_assignid / numeric data type
>B. njurisdictionid / numeric data type
>C. cjurisdictionname/ character data type
>
>I created a form based on this table and called it:
>"state_subor_assignment.scx"
>
>I placed the three fields indicated above onto the form.
>
>field "A" is simply a pk field which isn't posing a problem
>field "C" is working fine as well
>
>My issue is with field "B" (njurisdictionid)
>
>I created a combo box for this field, which is pulling its data from a view I created. So, in the combo box builder, I selected from that view, the fields:
>
>a. jurisname (which pulls up state names...ie; Florida, Alabama, etc.
>b. jurisid (associated id with each state name)
>
>I have the combo box set to"
>bound =2
>bound to =.T.
>
>When I run the form and selet that combo box, the states names appear just as I want. the problem comes with how the data is stored. When i go back to my table (state_subor_assignment.dbf), the combo box field doesn't say FLORIDA...... its shows me its associated id #.
>
>I want to have the table reflect the actual name >>> FLORIDA, or whatever i select.
>
>
>How can I get this to work. This is very important for when I am creating views and pulling information from this table. I want to see the actual name, not the id# associated with the name.
>
>Part of the problem is the data types don't match, but I don't know how to combat that.
>
>TIA for any help on this issue
>
>Jason