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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form Subform Issue 2
Acess 2003 - Form / SubForm linked fields 5
How to update underlying file 2
Unable to save subform field data to table 2
GrandTotal based on fields in two separate subforms... 4
Append Records from a subform to a new record 1
Save value from subform to table 1
Locked Subform still lets me delete a record 2

Back
Top