Update multiple record values from form/query

  • Thread starter Thread starter Todd H
  • Start date Start date
T

Todd H

I have a nested form with three subforms...I want to "cascade"
automatic records for each record I create in the main form. This is
a budget set up tool, and I am trying to populate the pending and
approved change fields as well as the billing fields. For each
"budget" record I set up, I want to automate the creation of a
"pending" change record, an "approved" change record, and a "payment"
record...all these records will tie together by their COSTCODE. What
is the best way to set this up?
 
I have a nested form with three subforms...I want to "cascade"
automatic records for each record I create in the main form.  This is
a budget set up tool, and I am trying to populate the pending and
approved change fields as well as the billing fields.  For each
"budget" record I set up, I want to automate the creation of a
"pending" change record, an "approved" change record, and a "payment"
record...all these records will tie together by their COSTCODE.  What
is the best way to set this up?
Click to expand...

Sorry for the multiple posts...I have started a new post with more
refined info.
 
Back
Top