Advice please on simple invoice database for deliveries and collections (1 Viewer)

hullstorage

Registered User.
Local time
Today, 23:19
Joined
Jul 18, 2007
Messages
213
Hi all,
I am creating a new database to input my customers deliveries and collections on a daily basis.
Then when all data has been added over a number of weeks we then print out an invoice for these and send to customer.

Am I heading in the right direction or can you recommend any changes to me.

[CUSTOMERS]
customerID
CompanyName
Address
Town
Postcode
Contact

[INVOICES]
InvoiceID
InvoiceNumber
InvoiceDate
CustomerID
BookingID
Terms
Complete yes/no

[BOOKINGS]
BookingID
BookingDate
CollectionID
DeliveryID
PurchaseOrderNo
£Cost

[FROM_ADDRESS]
CollectionID
Company
Address
Town
Postcode

[TO_ADDRESS]
DeliveryID
Company
Address
Town
Postcode

Here is the boring bit???

A customer calls us to to collect gods from an address, this could be either their own address or from elswhere in the country.
We then collect these goods and then deliver either back to our customer or possibly on some occasions to one of their own customers elswhere in the country.

Any suggestions would be much appreciated.

Thanks in advance all!! :)
 

Users who are viewing this thread

Top Bottom