Adding field from one table to another..

  • Thread starter Thread starter Dann
  • Start date Start date
D

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.
 
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...
 
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...
Click to expand...

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
 
Back
Top