Update two tables

  • Thread starter Thread starter Snurre
  • Start date Start date
S

Snurre

I have a form which is populated from a selection query.
The query has data from two tables. When I am trying to
edit data in the form, I am told that the recordset is
not updateable.

How can I update two tables from a form, using a
selection query???

Best regards
Snurre
 
It depends on HOW you are using data from two tables. It's not the form
that's the problem, it's the query that is being used as the record source
for the form. In the Help system, you can find information about when a
query is non-updateable. The most common problem is not having a Unique
Index on one the JOIN field in one of the tables.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Hi..

Thank you, that solved it.. Setting Primary Key and no duplicates for both
joined fields...

snurre
 
Back
Top