Form/subform linked field update

[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)?

 

[Allen Browne]

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.

 

[Doreen Kelly]

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)?

How do I delete old email from you?
Doreen