M
Mens Militis
I have a query connecting two tables in a one to many relationship, both have
a field (Boolean ie Check Mark) that must store the same value.
Example: if Table1.Field1 = True then Table2.Field2 must = True
I am displaying this query on a form, and want the user to be able to check
only the one field (table1.Field1), and i expect that to automaticly populate
the field with mutiple records (table2.field2) without having to use code
behind the check mark.
This is required due to the structure of my database, however, because of
the one to many relationship, i get a "must use an updatable query." error.
Is there any way to force this within the query without using code?
And why the ^%&$ hasn't Microsoft allowed for this ... it's been a problem
since Access 95.
Frustrated and Confused,
Mens Militis
a field (Boolean ie Check Mark) that must store the same value.
Example: if Table1.Field1 = True then Table2.Field2 must = True
I am displaying this query on a form, and want the user to be able to check
only the one field (table1.Field1), and i expect that to automaticly populate
the field with mutiple records (table2.field2) without having to use code
behind the check mark.
This is required due to the structure of my database, however, because of
the one to many relationship, i get a "must use an updatable query." error.
Is there any way to force this within the query without using code?
And why the ^%&$ hasn't Microsoft allowed for this ... it's been a problem
since Access 95.
Frustrated and Confused,
Mens Militis