Increment Total on Second Table from Form

[Paul Gurwitz]

I have two one-to-many related tables, "Jobs" and "Charges". Jobs has a
primary key called "Jobnum". Charges has a number of records relating
to each Jobnum; these records include information about specific
charges, including the amount, called "Charge". Jobs has a field called
"Totcharge" , which is the sum of Charges for all Charges in each Jobnum.

I have designed a form to input a new Charge record. When I click the
command button after having input the data, I would like to increment
Totcharge on the Jobnum record of Jobs by the amount of Charge.

What is the simplest way of doing this in Access?

Thanks
Paul

[Pieter Linden]

Re: Increment Total on Second Table from Form

Paul Gurwitz <pgurwitz@renai ss.com> wrote in message news:<hZQYb.107 34$hm4.1106@new sread3.news.atl .earthlink.net> ...[color=blue]
> I have two one-to-many related tables, "Jobs" and "Charges". Jobs has a
> primary key called "Jobnum". Charges has a number of records relating
> to each Jobnum; these records include information about specific
> charges, including the amount, called "Charge". Jobs has a field called
> "Totcharge" , which is the sum of Charges for all Charges in each Jobnum.
>
> I have designed a form to input a new Charge record. When I click the
> command button after having input the data, I would like to increment
> Totcharge on the Jobnum record of Jobs by the amount of Charge.
>
> What is the simplest way of doing this in Access?
>
> Thanks
> Paul[/color]

put an unbound control on your main form that does a DSUM of the subform records?