Query Not Updatable

[Wanda Foster via AccessMonster.com]

I have a simple table "tblVendor" and another table "tblNotes".
The structure for tblvendor is:

coID
CoName
JO#
SSN


The structure for tblNotes is:
coID
JO#
SSN
Notes
NoteDate
NoteTime


I created a query to join the two table based upon the tblVendor (all recds
in tblvendor and only those in tbl notes where joins are equal) I am
joining on the JO#.

No matter what I do, the query is NOT updatable. When I run the tables
separately, they ARE updatable. What am I doing wrong??

Thanks,
Wanda

 

[Jeff Boyce]

Wanda

Take a look in Access HELP on "updatable query".

I suspect you have not included the primary key field of the table you want
to update, so Access can't tell which record to update.

 

[Wanda Foster via AccessMonster.com]

That did it. Thanks!!