Query Not Updatable

  • Thread starter Thread starter Wanda Foster via AccessMonster.com
  • Start date Start date
W

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
 
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.
 
Back
Top