design help

hey all,
can someone please help me design the following:
9/29/05 Cut Lawn $20
Date of Service Service Type Price Payment Due Trans Type Payment
Amount Payment Date
9/29/05 Cut Lawn $20 10/29/05 Bill
9/29/05 Cut Lawn $20 10/29/05 Payment $10 10/1/2005
9/29/05 Cut Lawn $20 10/29/05 Payment $15 10/14/2005
Here's what I have so far:
Customer table
Invoice
InvoiceDetails
And here's where I need some help
Would I need a payment table? if so, how would it link to the invoice?
Also, where and how would you keep track of past due amounts and customers
who pay more than the amount billed?
thanks,
ariStart here:
http://www.databaseanswers.org/data...oices/index.htm
-oj
"ari" <ari@.discussions.microsoft.com> wrote in message
news:40BCFA96-97FC-432E-B7E8-19F78FDA7D53@.microsoft.com...
> hey all,
> can someone please help me design the following:
> 9/29/05 Cut Lawn $20
> Date of Service Service Type Price Payment Due Trans Type Payment
> Amount Payment Date
> 9/29/05 Cut Lawn $20 10/29/05 Bill
> 9/29/05 Cut Lawn $20 10/29/05 Payment $10 10/1/2005
> 9/29/05 Cut Lawn $20 10/29/05 Payment $15 10/14/2005
> Here's what I have so far:
> Customer table
> Invoice
> InvoiceDetails
> And here's where I need some help
> Would I need a payment table? if so, how would it link to the invoice?
> Also, where and how would you keep track of past due amounts and customers
> who pay more than the amount billed?
> thanks,
> ari|||Awesome.
Thanks,
ari
"oj" wrote:

> Start here:
> [url]http://www.databaseanswers.org/data_models/customers_and_invoices/index.htm[/url
]
> --
> -oj
>
> "ari" <ari@.discussions.microsoft.com> wrote in message
> news:40BCFA96-97FC-432E-B7E8-19F78FDA7D53@.microsoft.com...
>
>