Form/subform linked field update

  • Thread starter Thread starter Mary
  • Start date Start date
M

Mary

An order is linked to its details via subform field
Ordernum. This order # is temporary and needs to be
updated at a later time. How can I have the order number
change on the main form and that number correspondingly
change on the subform (retaining all other data)?
 
Open the relationships window: Tools | Relationships.

Double-click the line joining the 2 tables (Order and OrderDetail
presumably).

Check the box for:
Cascading Updates

Now if you change the OrderNum on the main form, the new value will cascade
to the related records in the OrderDetail table.
 
An order is linked to its details via subform field
Ordernum. This order # is temporary and needs to be
updated at a later time. How can I have the order number
change on the main form and that number correspondingly
change on the subform (retaining all other data)?
Click to expand...
How do I delete old email from you?
Doreen
 
Back
Top