>>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