<<
Single-table views are not editable if they contains any aggregate columns.  
Not sure what you mean by "adds two calculated columns", but if this is a 
calculation within the view, then the entire view is not editable.   Nor are 
sorted views.
>>

No, this is an editable view -- no aggregates, no GROUP BY.  It's editable in 
the BROWSEr, so I know it's working as expected.  Just not in forms.

The view definition is along the lines of:

CREATE VIEW TableDisp (Col1, Col2, FontColor) AS SELECT Col1, Col2, (IFGT(Col1, 
Col2, 'RED', 'BLACK'))

and Col1 and Col2, while editable in a BROWSE window are not editable in a form.
--
Larry

Reply via email to