updating joined tables

[Guest]

Whenever I join two tables, it doesn't seem to matter what kind of join I
use, (left, right, equi, etc.) but I can't update ANYTHING. (None of the
fields can be updated). Any help would be appreciated. Thanks

 

[Adam Turner via AccessMonster.com]

Whenever I join two tables, it doesn't seem to matter what kind of join I
use, (left, right, equi, etc.) but I can't update ANYTHING. (None of the
fields can be updated). Any help would be appreciated. Thanks

Post your update query please

 

[John Vinson]

Whenever I join two tables, it doesn't seem to matter what kind of join I
use, (left, right, equi, etc.) but I can't update ANYTHING. (None of the
fields can be updated). Any help would be appreciated. Thanks

You must have a unique Index (such as a Primary Key) on the joining
field in the "one" side table; preferably for efficiency, you should
use the Relationships Window to define a relationship between the two
tables.

See the online help topic "Updateable" for what makes a query
updateable or not.

John W. Vinson[MVP]