Hmm... I'm really surprised that this is editable at all with that calculation in there. I was under the impression it wouldn't be.
Can't help you. Don't think I've ever used a view in a form. Karen > << > 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 > > >
