update between Access and SQL

[Guest]

I'm using Access as a front end to SQL. Our product ID (key field) in the
Product Name table sometimes changes. I need all of the associated records
in the SQL Order table to change when a product Id is changed.

What is the best method to use? VB on an event -- or -- Run a SQL stored
procedure from Access? (novice level, please!)

How do I match the product ID between the two tables and then update the
associated table with the new Product ID?

 

[Guest]

Set a relationship between the Product Name table and the Order table and
check it to cascade update. You can do this by creating a New Database
Diagram in Enterprise Manager, drag and drop the appropriate fields, and set
the Relationships in the Properties dialog.