Adding field from one table to another..

[Dann]

I've hit a spot of trouble with my "Collections"
database.
I have on the "collections" form a command button that
calls the "Payments" form. The user fills in the Payment
form including customer number and PaymentAmt. I need the
PaymentAmt field to increment the "TotalPaid" field in
the Collections form/table then save the PaymentAmt into
the payment table and close. So far all I'm pretty sure
of is I need a VBA routine to do it.
Thanks,
D.

 

[Guest]

Dann

You should not be saving calculations (totalpaid). You can always retrieve
it later.

 

[Dann]

Users need the totalpaid in another calculation so we can
track how much the client still owes. The users are not
very sophisticated users, (just as I'm not a very
sophisticated developer) so they like things in front of
them...

 

[John Vinson]

Users need the totalpaid in another calculation so we can
track how much the client still owes. The users are not
very sophisticated users, (just as I'm not a very
sophisticated developer) so they like things in front of
them...

That is still no reason to violate relational integrity and store the
field!

You can recapitulate the calculation of totalpaid in the expression
which calculates the amount owed, or base the latter calculation on a
Query which itself calculates totalpaid. Unless there are MAJOR,
DEMONSTRABLE problems with this approach, you're better off with a
somewhat more complex query than with very possibly invalid data
stored in your table.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps