Loan payments database

[Martin Chapman]

Hi,
I created a database for my business, it has 2 tables, one with the customer details including the initial outstanding balance and the second a payments table.

They are displayed on the one form, with the second table as a subform in list form. The question is in the sub form i want a balance field that takes all payments for that customer in the payments table off the original outstanding balance. can this be done?

[nico5038]

The normalized way is to have three tables:
tblCustomer
tblInvoice, recording deliveries and ToPay
tblPayments, (part) payments for delivered stock items, so linked to the tblInvoice.

For getting the balance just sum "ToPay" and all (part) payments and determine the difference.

Getting the idea ?

Nic;o)