Query - issue editing with the tables

M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top