Unable to update query (Access 2000)

Topic

New Reply

I’m unable to update any fields in the query1 query in the attached db. The query is made up of 2 tables linked byu a common id field. I try to update the deliverytime field and it tells me “The recordset is not updateable.” Can any figure out what the problem is? Thanks..

Reply | Quote

Replies

You have no primary key in either table. Access can’t determine the nature of the link between the tables in the query, so it can’t decide what is to update what.

I would guess (but I may be wrong) that several record in ReceiptNumbers can belong to one record in IDC RECPT TBL. If that is correct, do the following:

• Set the primary key in ID RCPT TBL on the ID field.
• Set the primary key in ReceiptNumbers on the Receipt# field.
• In the Relationships window, create a relationship between the two tables from ID in IDC RCPT TBL to RCPT ID in ReceiptNumbers.
• Set referential integrity for this relationship, with cascading updates. You can also set cascading deletes if you want a receipt number to be deleted when its receipt is deleted.
  [/list]The query should now be updateable.

Reply | Quote

Thanks Hans. I thought that might be the problem. Thanks again..

Reply | Quote