Simple monthly billing / invoice / payment DB

[Fox]

Hello!



I've been trying to create a database for my business but I've basically hit a brick wall.

I've managed to create a DB that can create invoices via a form using the following Tables:

Customer - Order - OrderLine - Product.

I want to be able to add payments but no matter what I do I don't seem to be able to get it to work.

Does anyone have an easy solution? I know what I'm trying to do is simple but I seem to have gone DB blind!

Many thanks

[CJ_London]

easy solution might be to start with one of the templates - desktop business account ledger for example?

[Fox]

Thanks, I'll have a look

[Minty]

If you want a very simple solution have a payments table something like

tblPayments	Data Type	Notes
PaymentID	Autonumber	PK
OrderID		FK - back to your order header
Amount	Currency
PaymentDate	Date

Then a simple sum of payments against matching Order header totals would tell what has and hasn't been paid.