Question Advice with New Database Project Please (1 Viewer)

[hullstorage]

Hi all,
I am looking a create a Database for Deliveries and Collections we do.
We are a small transport company so this is something like what we need.
On a daily basis we collect and deliver parcels for various customers.
The customers in question may have an Invoice/Accounts address that
differs from their warehouse address where we would collect from.
i.e.
[ Head Office-where we send Invoices to]
Joe Bloggs
Joe Bloggs House
Main Road
Hull
HU1 1NP
[Warehouse - where we would collect from]
Joe Bloggs
Unit 12
Suttonfields Ind Est
Hull
HU7 1NP
So when a customer books a job and we select that customer the collection address
would be by default the warehouse address:
Here are all the fields i will be working with, as you may see this setup which we are currently
using is not ideal and we would like help in tidying it up and also creating Relaionships.
We also need to setup some sort of Invoicing system into it i.e. Invoice Table etc..
Please note that some customers will have upto 30 jobs per invoice and will be Invoiced
at the end of each Month

[CustomersTBL]
CustomerID
CustomerName
Address1
Address2
Town
County
Postcode
Contact
Telephone
Fax
CollectFrom
Address3
Address4
Town2
County2
Postcode2
Contact2
Telephone2
Fax2

[BookingsTBL]
BookingID
BookingDate
CustomerID
AccountNumber
CollectFrom
Address3
Address4
Town2
County2
Postcode2
Contact2
Telephone2
Fax2
DeliverTo
Address5
Address6
Town3
County3
Postcode3
Contact3
Telephone3
Fax3
NoItems
Weight
CustomerOrderNo
Driver
ServiceRequired
£Cost
InvoiceStatus ( is invoiced yes or no )

[DriversTBL]
DriverID
DriverName
MobileNumber
HomeNumber

[SERVICETBL]
ServiceID
ServiceRequired

[UKPOSTCODES] ( this table already has all of the UK Postal code details in it )
PostcodeID
Postcode
Street
Town
County

 

[music_al]

Hi

I could help you out with this. Im trying to set up a small sideline business to create Access databases. Ive got a couple of databases out there with customers that are working quite nicely.

I would be looking to charge a SMALL fee but for something like this shouldnt take more than a couple of days.

Let me know if youre interested.


Al

 

[music_al]

Ive got a couple of spare days. Send me over your tables and I'll do it for ya - NO CHARGE !!

I sent you my email address