query no updatable

[Fredrated]

I have a query which seems simple enough, but it is not updatable, any ideas
why?

I have 2 tables, PDAs and Contacts.
I have a many to many table to relate them, because a PDA can have multiple
contacts, and a contact can be a contact for multiple PDA's

The key to the PDA table is 'KEY' (not my idea), and the key to the contact
table is 'contact_id'

The intermediate table, PDA_Contacts is 2 fields, 'KEY' and 'contact_id',
and together they make up the key for this table (called pda_contacts).

I am trying to base a form on a query that relates pda_Contacts to Contacts
by the field contact_id (to be the basis of a subform that allows the
addition of contacts to PDAs). However, this query will not allow edits to
contact information!
I can update contact information in a query which has only that table, but
as soon as I add the table pda_contacts, the query cannot be updated.

Any ideas?

Thanks in advance for any help.

Fred

 

[Allen Browne]

The most likely reason is that the field on the ONE side of the join is not
uniquely indexed.

Here's a list of other possible reasons:
Why is my query read-only?
at:
http://allenbrowne.com/ser-61.html

 

[Fredrated]

You are awesome! When I went back and inspected the contact table I found
that it had an autonumber field for id, but it had not been made the primary
key, and the index MS had created by default was not unique. When I made
this the primary key the query became updatable. Thank you very much for
your valuable help.

I bookmarked your help page for future reference.

 

[Jeanette Cunningham]

Hi Fredrated,
here is a link to information about queries that can't be updated.

http://allenbrowne.com/ser-61.html


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia