K
kfng
I have a select query (Q1) based on another two select queries(Q2: involving
2 tables with one-to-one relationship and Q3:involving 3 tables with
one-to-many relationship between each table). Now, I have a set of criteria
which is applied to the primary key field of one of the tables underlying Q2
and Q3) and based on this criteria, I would like to update a yes/no box in Q1
so that they will all be checked "yes". I created an update query to do that
.. It seems that only a few records got checked and then the remaining
records even though fulfiling the criteria remain unchecked. When I tried to
run the update query, it keeps telling me that I have a key vilolation and I
can't update the records.
I'm new to Access and I know the way I'm doing this may be clumpsy so I'd
appreciate any better way to do this updating thing. Thanks.
2 tables with one-to-one relationship and Q3:involving 3 tables with
one-to-many relationship between each table). Now, I have a set of criteria
which is applied to the primary key field of one of the tables underlying Q2
and Q3) and based on this criteria, I would like to update a yes/no box in Q1
so that they will all be checked "yes". I created an update query to do that
.. It seems that only a few records got checked and then the remaining
records even though fulfiling the criteria remain unchecked. When I tried to
run the update query, it keeps telling me that I have a key vilolation and I
can't update the records.
I'm new to Access and I know the way I'm doing this may be clumpsy so I'd
appreciate any better way to do this updating thing. Thanks.