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

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

Post by SmltIE1jR » Sat, 03 Jan 2009 17:18:01


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?
--
Jim
 
 
 

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

Post by Stefan Hof » Sat, 03 Jan 2009 19:37:52

hi Jim,


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 <--

 
 
 

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

Post by SmltIE1jR » Wed, 07 Jan 2009 16:05:01

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.
--
Jim
 
 
 

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

Post by Stefan Hof » Wed, 07 Jan 2009 20:31:05

hi Jim,


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


mfG
--> stefan <--