Barbara,

Yes, I did try all-sorts through the command window in any case the original view should specify table name anyway.

Everthing works OK if your numeric field is something other than 'number' which being a reserved word probably should not be used anyway.

>Glenn, does it make a difference if you include the table name (table1.number instead of just number?) If so, you might be able to work around the problem. We had a similar one with existing fields named 'desc' in some updated tables, and using the table name helped substantially.
>
>hth
>Barbara