Update multiple record values

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

Todd H

I am not sure where to start with this issue. I have a simple budget/
cost tracking data base that has three tables; tblTracking,
tblLineItems, and tblPayments.

tblTracking has the following fields: RecordNo(key), Title, and
Approved(Y/N)
tblLineItems has LIID(hidden key), RecordNo, CostCode, Amount
tblPayments has PMTID(hidden key), CostCode, Amount, BillingPeriod

To set up the initial budget, I use three RecordNo's to populate the
Budget, PendingChanges and ApprovedChanges. I then isolate those
records and ignore them when entering changes; I use RecordNo's "9998"
for the Budget (Approved=Yes, cost codes and amounts), "9999" for the
PendingChanges (Approved=No, cost codes match record 9998 and amount
is 0 for each code) and "0000" for the ApprovedChanges (Approved=No,
cost codes match 9998 and amount is 0 for each code). Then, to
populate the Payment field, I set BillingPeriod 01 with an Amount of
0.

What I want to do is set up a "Budget Entry" form that will allow me
to enter a cost code and a "Budget" amount that will populate record
9998 and also populate record 9999 and 0000 as well as the tblPayment
record that corresponds to the cost code. RIght now, I have forms
that allow me to do this all separately (each record in a "tracking"
form that has a "LineItem" subform, and then over to a "CostCode" form
that has a "Payment" subform).

I know there is a way to do this, but I am at a loss as to what you
call it or how to set it up (or search for it on this forum). Any
help is greatly appreciated.

Thanks, Todd
 
I am not sure where to start with this issue.  I have a simple budget/
cost tracking data base that has three tables; tblTracking,
tblLineItems, and tblPayments.

tblTracking has the following fields: RecordNo(key), Title, and
Approved(Y/N)
tblLineItems has LIID(hidden key), RecordNo, CostCode, Amount
tblPayments has  PMTID(hidden key), CostCode, Amount, BillingPeriod

To set up the initial budget, I use three RecordNo's to populate the
Budget, PendingChanges and ApprovedChanges.  I then isolate those
records and ignore them when entering changes; I use RecordNo's "9998"
for the Budget (Approved=Yes, cost codes and amounts), "9999" for the
PendingChanges (Approved=No, cost codes match record 9998 and amount
is 0 for each code) and "0000" for the ApprovedChanges (Approved=No,
cost codes match 9998 and amount is 0 for each code).  Then, to
populate the Payment field, I set BillingPeriod 01 with an Amount of
0.

What I want to do is set up a "Budget Entry" form that will allow me
to enter a cost code and a "Budget" amount that will populate record
9998 and also populate record 9999 and 0000 as well as the tblPayment
record that corresponds to the cost code.  RIght now, I have forms
that allow me to do this all separately (each record in a "tracking"
form that has a "LineItem" subform, and then over to a "CostCode" form
that has a "Payment" subform).

I know there is a way to do this, but I am at a loss as to what you
call it or how to set it up (or search for it on this forum).  Any
help is greatly appreciated.

Thanks, Todd
Click to expand...

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