Changing Data of a bound/linked field?

[Ed-Masto]

Hello All:

I have what seems to be a problem I cannot resolve. To begin with, I am a
very amateur access developer/user with very limited SQL skills. Most
everything I know has been self-taught. With that said here is my issue.

I have a primary table called SalesOrderHeader and a linked table
(OrderNo=OrderNo) details table called OrderDetails. Within the OrderDetails
Table there is a lookup field called ProductNo which links to the Products
Table. So far everything is working great.

The problem is that on occasion I need to rename a ProductNo in the Product
Table. Remember, ProductNo is the bound field in the lookup from the
SalesOrderDetails Table. When I change the ProductNo in the Products Table,
is there any way to have the program check/change the SalesOrderDetails Table
as needed (what I mean is also change the ProductNo in the SalesOrderDetail
Table)?

Much thanks!!

 

[Allen Browne]

Sure.

Open the Relationships window (Database Tools tab of the Ribbon in Access
2007, or the Tools menu in earlier versions.)

Double-click the line joining Products.ProductNo to OrderDetails.ProductNo.
Access opens the Edit Relationship dialog.

Check the box for Cascading Update.

 

[Ed-Masto]

Much Thanks!

You guys are the best help!

Sure.

Open the Relationships window (Database Tools tab of the Ribbon in Access
2007, or the Tools menu in earlier versions.)

Double-click the line joining Products.ProductNo to OrderDetails.ProductNo.
Access opens the Edit Relationship dialog.

Check the box for Cascading Update.