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?
Code:
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.