Query that allows update on M-to-M table

[journeyman]

Hi All.



I have a table with 2 fields (IO, F1)

I have a second table with 4 fields (ID, F1, F2, F3)

T1 (F1) - contains unique records.
The data in F1 ranges from 1-10
T1 is filtered to a value (or several)

T2 (Both F1 and F2) contains duplicate string type fields.
The data in F2 ranges from 1 to 10.

T2 (F3 is a Yes/No field)

With a basic select query I can see all my filtered records

I need a query that displays all the filtered records and allows for me to modify the Boolean F3 field.

Sounds simple, but my every attempt has ended in tears. I cannot modify the F3 Field. Just why?

Select Tbl_Temp2.*
From Tbl_Temp INNER JOIN Tbl_Temp2 ON Tbl_Temp.f1 = Tbl_Temp2.F1

Surely there has to be a simple way to allow for me to select a stupid Boolean field.

Any help is appreciated.

[June7]

Is this a RecordSource for a form? Are you trying to manually edit field? Why are you using a JOIN query to edit T2?

Should still be able to edit F3.

There is no filter applied.

If you want to provide db for analysis, follow instructions at bottom of my post.

[Gicu]

See if changing the recordset type of the query to dynaset (Inconsistent Updates) helps. Open the query in design view and go to properties:

Cheers,

[journeyman]

Hi all,

The advice to change to inconsistent updates set me on the right path. thank for understanding the question and responding appropriately.