Why might a query drawn from three nested tables refuse to update?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The outer form is based on the 'Site' details table and the main form for all
input of data. Nested in the 'Site' details form is a form for identifying
each new 'Survey' conducted. 'Species' details are then nested within the
'Survey' details. When drawing information to create a query from each of the
three tables on which the forms are based, the query refuses to update - it
appears to be locked and uneditable. Is this fixable without redesigning the
database?
 
Hi,


doable in Northwind:

Make a new query with Tables: Orders, OrderDetails and Products. Bring all
the fields (*) in the grid. In dataview, we can change the OrderDate (from
OrderDetailss) as well as UnitPrice (from Products) and Discontinued ( from
Products)

it can also be done with something else than a junction, such as with the
cascade: Suppliers, Products, and OrdersDetails


It is not updateable if ANY of the table (or query used as table) has an
aggregate (or GROUP BY clause, or DISTINCT, or TRANSFORM), among other
things. A computed field (and an autonumber) is not updateable. If a single
modification has to performed and if a UNIQUE record to be modified cannot
be identified, the update is not possible either. In our example, by
extension, Products.Discontinued can be modified, but you observe that doing
so, it changes all the rows, in the result, that supply the value you
changed, not just the record of the result you edit. The field is updateable
because the single record supplying the



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top