editing a set of records selected from value in a second table

[Jim McD]

A novice question: I want to be able to edit a group of records selected from
table 3 based on a selection of values in table 2, in turn based on a single
records in table 3. The join that enables the selection of records from table
1 also prevents me from editing the records in table 1. I do not want to
change any values in tables 1 or 2. This applies to the query as well as the
form even though the query has records locks set for "no locks". Any thoughts
about how I might get around this, please?

 

[Stefan Hoffmann]

hi Jim,

A novice question: I want to be able to edit a group of records selected from
table 3 based on a selection of values in table 2, in turn based on a single
records in table 3. The join that enables the selection of records from table
1 also prevents me from editing the records in table 1. I do not want to
change any values in tables 1 or 2. This applies to the query as well as the
form even though the query has records locks set for "no locks". Any thoughts
about how I might get around this, please?

Recordsets are only updateable when Access/Jet can identify all rows by
their primary keys. A query must be key-preserving.
This seems not be the case, so you may simply try appending all primary
key fields from all three tables to your query.


mfG
--> stefan <--

 

[Jim McD]

Thanks for that Stefan. I don't actually want to change the other 2 tables.
this is a roster program with shifts for staff. I am trying to select the
shifts for a particular fortnight so I can edit them. But I cannot add, edit
or delete because they are tied in the query to the table that specifies the
period I want to look at. Do you know of some way of selecting the records
out of a table by a filter that is determined by the value in another table?
I cannot see a way of doing this but logically it should not cause a problem
for the database I reckon.

 

[Stefan Hoffmann]

hi Jim,

Thanks for that Stefan. I don't actually want to change the other 2 tables.
this is a roster program with shifts for staff. I am trying to select the
shifts for a particular fortnight so I can edit them. But I cannot add, edit
or delete because they are tied in the query to the table that specifies the
period I want to look at. Do you know of some way of selecting the records
out of a table by a filter that is determined by the value in another table?
I cannot see a way of doing this but logically it should not cause a problem
for the database I reckon.

You may post your queries SQL so far and involved tables...


mfG
--> stefan <--