Query - issue editing with the tables

[Mike]

Hi All,

I'm having an issue where I can't edit the tables through
querying. First I created two tables, user, and
information. In the user table, I have a field name "user
ID" and it is a primary key. In the information table, I
have the same field "user Id" and it is also the primary
key. When I create a query to retrieve the datas from both
tables, I can edit the retrieved data from the querying
table. But when I changed the primary key in the
information table to "informationID" and "User ID" is
being as a foriegn key referencing from the user table. I
can not edited the retrieved data from the querying table.

Is there a way that I can edit the retreived datas from
the querying table with userID as a foreign key, instead
of being a primary?

Thanks for the help...
Mike

 

[John Viescas]

When you changed the keys in the Information table, were you careful to also
remove the unique index from UserID? I think that might be the problem.
You should otherwise be able to edit data in a 1->M query that joins Users
with Information.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
http://www.deanforamerica.com/site/TR?pg=personal&fr_id=1090&px=1434411