Weird, you're right. Try re-creating the view from scratch.

>>>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.
>
>
>view 4
>

>SELECT Busin_profit.itemdesc, Busin_profit.period1,;
>  Busin_profit.period2, Busin_profit.period3, Busin_profit.period4,;
>  Busin_profit.period5, Busin_profit.period6, Busin_profit.period7,;
>  Busin_profit.period8, Busin_profit.period9, Busin_profit.period10,;
>  Busin_profit.period11, Busin_profit.period12,;
>  Busin_profit.period_total;
> FROM mainbase!busin_profit;
>   where busin_profit.itemtype='e'
>
>
>DBSetProp(ThisView,"View","SendUpdates",.F.)
>DBSetProp(ThisView,"View","BatchUpdateCount",1)
>DBSetProp(ThisView,"View","CompareMemo",.T.)
>DBSetProp(ThisView,"View","FetchAsNeeded",.F.)
>DBSetProp(ThisView,"View","FetchMemo",.T.)
>DBSetProp(ThisView,"View","FetchSize",100)
>DBSetProp(ThisView,"View","MaxRecords",-1)
>DBSetProp(ThisView,"View","Prepared",.F.)
>DBSetProp(ThisView,"View","UpdateType",1)
>DBSetProp(ThisView,"View","UseMemoSize",255)
>DBSetProp(ThisView,"View","Tables","mainbase!busin_profit")
>DBSetProp(ThisView,"View","WhereType",3)
>
>DBSetProp(ThisView+".itemdesc","Field","DataType","C(40)")
>DBSetProp(ThisView+".itemdesc","Field","UpdateName","mainbase!busin_profit.itemdesc")
>DBSetProp(ThisView+".itemdesc","Field","KeyField",.F.)
>DBSetProp(ThisView+".itemdesc","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".period1","Field","DataType","N(15,2)")
>DBSetProp(ThisView+".period1","Field","UpdateName","mainbase!busin_profit.period1")
>DBSetProp(ThisView+".period1","Field","KeyField",.F.)
>DBSetProp(ThisView+".period1","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".period2","Field","DataType","N(15,2)")
>DBSetProp(ThisView+".period2","Field","UpdateName","mainbase!busin_profit.period2")
>DBSetProp(ThisView+".period2","Field","KeyField",.F.)
>DBSetProp(ThisView+".period2","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".period3","Field","DataType","N(15,2)")
>DBSetProp(ThisView+".period3","Field","UpdateName","mainbase!busin_profit.period3")
>DBSetProp(ThisView+".period3","Field","KeyField",.F.)
>DBSetProp(ThisView+".period3","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".period4","Field","DataType","N(15,2)")
>DBSetProp(ThisView+".period4","Field","UpdateName","mainbase!busin_profit.period4")
>DBSetProp(ThisView+".period4","Field","KeyField",.F.)
>DBSetProp(ThisView+".period4","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".period5","Field","DataType","N(15,2)")
>DBSetProp(ThisView+".period5","Field","UpdateName","mainbase!busin_profit.period5")
>DBSetProp(ThisView+".period5","Field","KeyField",.F.)
>DBSetProp(ThisView+".period5","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".period6","Field","DataType","N(15,2)")
>DBSetProp(ThisView+".period6","Field","UpdateName","mainbase!busin_profit.period6")
>DBSetProp(ThisView+".period6","Field","KeyField",.F.)
>DBSetProp(ThisView+".period6","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".period7","Field","DataType","N(15,2)")
>DBSetProp(ThisView+".period7","Field","UpdateName","mainbase!busin_profit.period7")
>DBSetProp(ThisView+".period7","Field","KeyField",.F.)
>DBSetProp(ThisView+".period7","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".period8","Field","DataType","N(15,2)")
>DBSetProp(ThisView+".period8","Field","UpdateName","mainbase!busin_profit.period8")
>DBSetProp(ThisView+".period8","Field","KeyField",.F.)
>DBSetProp(ThisView+".period8","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".period9","Field","DataType","N(15,2)")
>DBSetProp(ThisView+".period9","Field","UpdateName","mainbase!busin_profit.period9")
>DBSetProp(ThisView+".period9","Field","KeyField",.F.)
>DBSetProp(ThisView+".period9","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".period10","Field","DataType","N(15,2)")
>DBSetProp(ThisView+".period10","Field","UpdateName","mainbase!busin_profit.period10")
>DBSetProp(ThisView+".period10","Field","KeyField",.F.)
>DBSetProp(ThisView+".period10","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".period11","Field","DataType","N(15,2)")
>DBSetProp(ThisView+".period11","Field","UpdateName","mainbase!busin_profit.period11")
>DBSetProp(ThisView+".period11","Field","KeyField",.F.)
>DBSetProp(ThisView+".period11","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".period12","Field","DataType","N(15,2)")
>DBSetProp(ThisView+".period12","Field","UpdateName","mainbase!busin_profit.period12")
>DBSetProp(ThisView+".period12","Field","KeyField",.F.)
>DBSetProp(ThisView+".period12","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".period_total","Field","DataType","N(15,2)")
>DBSetProp(ThisView+".period_total","Field","UpdateName","mainbase!busin_profit.period_total")
>DBSetProp(ThisView+".period_total","Field","KeyField",.F.)
>DBSetProp(ThisView+".period_total","Field","Updatable",.T.)
>
>

>
>its not finding Period_total an i have it in my busin_profit table. it sometimes sees it in the view designer cause i added it 2 selected fields but it doesnt let me save that SQL