"ari" <a**@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

"oj" wrote:

> Start here:
> http://www.databaseanswers.org/data_models/customers_and_invoices/index.htm
>
> --
> -oj
>
>
> "ari" <a**@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
>
>
>