>HEllo!
>i recently added another field to a table. but now im trying to create a view for that table oddly the view only sees the new field when my table name magically morphs to "table_a"so i close table all and then i saw the new field in the available fields column(thats in view designer) but when i write my SQL using my new column it says it cant be found...which is very odd cause im lookin at it.yes its spelt right

Post your view definition.