Update query

[Radhika]

How can I update a field in a table on the one side of a one-to-many
relationship?
It does not seem to work using an update query. Is there a way to make it
work in an update query? If not, is there any other way in which i can do
this?

I cannot add an expression to the after update event of the field on a form
as the field needs to be updated based on values in calculated fields.

Thank you
Radhika

 

[Clifford Bass]

Hi Radhika,

Could you tell us some more information, such as the tables and columns
involved and how the tables are related? Also, what field(s) you are trying
to update and any errors you are getting.

Clifford Bass

 

[Allen Browne]

Use a Cascading-Update so the matching records in the related table get
changed automatically when you change the value on the ONE side of the
relationship.

Open the Relationships window.
Make sure you have a relationship between the 2 tables.
Double-click the line joining them.
Access pops up the Edit Relationships dialog.
Check the box for Cascading Updates.

(You must have the Referential Integrity checked or the Cascading Updates
box is disabled.)