Subject | Re: [IBO] Editable/Insertable join? |
---|---|
Author | Geoff Worboys |
Post date | 2001-07-06T11:44:16Z |
> When I set QryContact.KeyRelation to ADRESSEN, then theA query can only setup to automatically edit/insert/delete against ONE
> CONTACT table is not editable.
> When I set QryContact.KeyRelation to CONTACT, then the
> ADRESSEN table is not editable.
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.
HTH
Geoff Worboys
Telesis Computing