Update multiple record values from form/query

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

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

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

Top