Subject Re: [IBO] Editable/Insertable join?
Author Geoff Worboys
> When I set QryContact.KeyRelation to ADRESSEN, then the
> CONTACT table is not editable.
> When I set QryContact.KeyRelation to CONTACT, then the
> ADRESSEN table is not editable.

A query can only setup to automatically edit/insert/delete against ONE
entity. If you use joins and want to edit all entities you will have
to supply our own editsql, insertsql and deletesql.

Your simplest solution is to NOT use a join. Separate the two
entities ADRESSEN and CONTACT into their own queries with a
master/detail relationship between them. master/detail will work just
as well for one-to-one as it does for one-to-many.


Geoff Worboys
Telesis Computing