Multi Table Query & Locked fields

[JdeC]

I have a simple 3 table DB with one primary table and two supporting tables.
Table 1 - contains ID field set as primary key and AutoNumber property with 1 field set as text
Table 2 - Has T2_ID (AutoNumber and set as primary key), ID field properties number (Long Integer) and 1 field set as text
Table 3 - Has T3_ID (AutoNumber and set as primary key), ID field properties number (Long Integer) and 1 field set as text
Relationship defined as below with referential integrity defined

The query defined as "SELECT Table1.FIELDT1, Table2.FIELDT2, Table3.FIELDT3 FROM (Table1 INNER JOIN Table2 ON Table1.ID = Table2.ID) INNER JOIN Table3 ON Table1.ID = Table3.ID;"
Why is it that I am not able to edit the text fields in MS Access 365 but am able to do so in other databases?

[ranman256]

depending on the query, the result set MAY be locked.
depends on your tables & keys & joins.

some you can edit, some not.

[JdeC]

Thanks ranman256, however in the above it the definition is the most simple one can define; yet I am not able to make changes to the fields and do not understand why.

[Gicu]

Are the two ID fields in table 2 and 3 indexed (duplicates OK)?
Cheers,

[JdeC]

Yes they are.

[Gicu]

Please review http://allenbrowne.com/ser-61.html for reasons why your query is read-only.

You can try to open it in design view, bring up its Properties window and change the recordset type from Dynaset to Dynaset (Inconsistent Updates). If the query is used as the record source for a form to make the edits you will have to also set the form's recordset type to inconsistent updates.

Cheers,

[JdeC]

Thank-you Vlad, greatly appreciated the problem is now solved. The change of the recordset type to "Dynaset (Inconsistent Updates)" certainly did the trick.

[Gicu]

Glad to hear, good luck with your project!
Cheers,
Vlad