complex query

[Grip]

I'm trying to build a complex form and can't figure out the underlying
query.

The larger problem involves tables for Memberships (PeopleID, OrgID),
People, Organizations, PhoneNumbers(OrgID), Emails(OrgID),
PostalAddresses(OrgID).

Phone numbers can have the type of Office or Fax, and there can be
more than 2 numbers for an Org, but only one each for office and fax
will show on the form. But I'm getting ahead of myself.

I can't seem to create a query that will allow me to edit all the
information in a form.

I've tried building the query in a couple ways, and have reduced the
problem to this:

I've got tblMemberships joined to both tblOrganizations (via OrgID)
and tblPeople (via PeopleID). I can view all the fields I want and
edit them. A membership must have a person and an organization
associated with it, but people and orgs can have more than one
membership

But once I add the tblEmail, to the graph, I can't edit anything
anymore, unless I set it to Dynaset - Inconsistent Updates, which
doesn't help as the key isn't entered.

Should I just give up on the query and use sub forms?

Any help would be appreciated.

Thanks.

 

[S.Clark]

A single query probably won't work. Go with the forms/subforms. (I see you
did by your other post.)