Re: subform (again)

"Frank Schoenheit, Sun Microsystems Germany" <[email protected]>
Newsgroups gmane.comp.openoffice.dba.user
Message-ID <[email protected]>
Hi Fernand,

still without having looked at Franco's sample DB ....

> I only can reproduce the Calculated field error, who is no error but a 
> mistake from Franco who uses a query as a datasource for a subForm.
>  Franco:  change the datasource to the table where the Form-data must 
> been inserted and forgot the calculated field.

There's not really a compelling reason why sub forms should not work
with calculated fields or default values, neither technical nor
conceptual. The approach has its limits, for instance, queries over
multiple tables are not updatable, but this doesn't depend on their
usage in sub forms.

Ciao
Frank

-- 
- Frank Schönheit, Software Engineer         [email protected] -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Base                       http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.