Query non-updateable when composite key field used.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello:
My form wouldn't let me update, then I realize that my query is not updateable
either.
The properties are set to "Dynaset" and the other restrictions are set
correctly to allow updates.

I have two tables that contain two fields each. These fields are the
composite key of each table. When these field are added to the query, the
query becomes non-updateable. When they are removed, the query is updateable.

What is the reason for this? How could I make it an updateable query, but a?
 
Please post details of your Tables, specify the PKs from each Table and the
SQL String of the Query that you want to update from.
 
Back
Top