Hello gurus,
I am stuck!
[1] I'm accessing the DB via ODBC.
[2] The SQL Query consists of multiple tables.
[3] Each table in the query has primary key.
[4] The query is used for the RecordSource of the SubForm.
[5] The RecordSetType of the SubForm is "Dynaset (Inconsistent Updates)".
I also made the RecordSetType of the MainForm as "Dynaset (Inconsistent Updates)".
[6] The AllowEdits of my SubForm and MainForm are set to "Yes".
[7] My SubForm is in Datasheet View so that I can directly edit the data.
[8] The editable fields in the SubForm are Enabled=Yes and Locked=No.
Now..................
I can easily do SELECT query.
No problem with this.
The data are displayed as expected.
But..................
I can't edit the data.
The status at the bottom says, "This Recordset is not updatable".
why?
Did I miss something?
How can I make the displayed data editable/updatable?
May a good samaritan Access guru gives attention on this matter.
Someone who can provide the panacea of this woe.
I am stuck!

[1] I'm accessing the DB via ODBC.
[2] The SQL Query consists of multiple tables.
[3] Each table in the query has primary key.
[4] The query is used for the RecordSource of the SubForm.
[5] The RecordSetType of the SubForm is "Dynaset (Inconsistent Updates)".
I also made the RecordSetType of the MainForm as "Dynaset (Inconsistent Updates)".
[6] The AllowEdits of my SubForm and MainForm are set to "Yes".
[7] My SubForm is in Datasheet View so that I can directly edit the data.
[8] The editable fields in the SubForm are Enabled=Yes and Locked=No.
Now..................
I can easily do SELECT query.
No problem with this.
The data are displayed as expected.
But..................
I can't edit the data.

The status at the bottom says, "This Recordset is not updatable".
why?

Did I miss something?
How can I make the displayed data editable/updatable?
May a good samaritan Access guru gives attention on this matter.
Someone who can provide the panacea of this woe.