Mike: Go to TABLES in the Top Form menu and select "Add/Remove Tables..." Under slave tables select you second table and click Settings and makes sure that the five boxes under row settings are checked. Hopefully that will solve your problem...
Javier, Javier Valencia 913-915-3137 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of MikeB Sent: Tuesday, October 28, 2008 5:17 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Single table view NOT editable in form? I wouldn't have taken the view description as a calculation. The Ifgt is just mapping which col to assign to FontColor. So it's still a single table view. ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Tuesday, October 28, 2008 6:08 PM Subject: [RBASE-L] - Re: Single table view NOT editable in form? > 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 >> >> >> >
