>If i'm not mistaken, I faced the same problem as yours before, and I changed field name on the table (dbf) which is used by view, usually it's the field used in "where" clause on the view.
>As example:
>Create Sql View as Select * from mytable where field1=(expression)
>
>change the name of field1 to myfield1 or whatever
>
>HTH :)

I don't have a where clause. It's a very simple view. One table, selected fields, ordered by one field.

I can run the view with no problems. It's only when I try to use it in the list box that I have problems.

Thanks,

-Michelle