hullstorage
Registered User.
- Local time
- Today, 21:57
- Joined
- Jul 18, 2007
- Messages
- 213
i am quite new to this so please go easy on me!!!
i have looked at northwind but all looks a bit complicated at the moment
right here goes!
i am trying to create a database to enter multiple orders on and then print invoices on the program at a later date, these are the fields i am working with:
please bare in mind that the customer will place multiple orders daily
and is not invoiced until the end of the month:
how do i link these to work with each other
does anyone have a small sample database they can let me view or download:
[customer table]
acc no
customer name
address
telephone no
[invoice table]
invoice no
invoice date
customer
£ amount
£ vat
£ gross
[order table]
order date
job no
acc no
customer name
job details
customer ord no
£ amount
£ vat
£ gross
i have looked at northwind but all looks a bit complicated at the moment
right here goes!
i am trying to create a database to enter multiple orders on and then print invoices on the program at a later date, these are the fields i am working with:
please bare in mind that the customer will place multiple orders daily
and is not invoiced until the end of the month:
how do i link these to work with each other
does anyone have a small sample database they can let me view or download:
[customer table]
acc no
customer name
address
telephone no
[invoice table]
invoice no
invoice date
customer
£ amount
£ vat
£ gross
[order table]
order date
job no
acc no
customer name
job details
customer ord no
£ amount
£ vat
£ gross