>I have a combo that has four columns: subdivision, county, state, Upper(subdivision+county+state). The first three columns show in the drop down, the fourth column is just used to sort the array in what the client's consider "correct sort order". My problem is that I need to bind to m.subdivision+m.county+m.state, but I do not want to show that column in the drop down. Does the bound to column always have to be the first? If not, how do i specify which column to bind to? If so, how do I not show the first column in the drop down.
>
>thanks
>
>Brenda
No it doesn't need to be. You actually don't even need columncount=4 nor boundcolumn, 3 is enough. Think of using RowSourcetype=3 (SQL).
Cetin