Question New Project Help Please (1 Viewer)

[hessleroader]

PLEASE NOTE THAT THIS IS NOT A COMPLEX DATABASE IT SIMPLY FOR CREATING DELIVERY NOTES AND THERE WILL BE NO INVOICING OR INVENTORY INVOLVED.

WE BASICALLY ENTER DELIVERY DETAILS FROM A FAX AND WHAT TYPE OF GOODS THEY WANT.

I have now sorted out all the field required and need to see what needs to be where i.e. tables and relationships

We have a customer that on a daily basis will send us a fax for his deliveries.
On these fxes are various types and quantities of furniture to different address's
Here is couple below to show you what i mean:

PLEASE NOTE THAT THESE DELIVERIES ARE PRIVATE HOUSHOLD ADDRESS'S AND THEY WILL ONLY EVER
ORDER ONE DELIVERY SO MAY NOT NEED AS MANY TABLES I THINK


FAX DATE: 11/06/2009 - DELIVERY NUMBER 1
======================================
MR JONES MR SMITH
37 HIGH STREET 118 WOLD ROAD
HULL LONDON
HU3 6TF SW18 1JU

01482 666222 0779223232

1X 10FT TEAK TABLE 1X 8FT TEAK TABLE
8X TEAK STACKING CHAIRS 6X TEAK FOLDING CHAIRS
8X CUSHIONS 6X PADS
=======================================

AS YOU CAN SEE THERE IS MORE THAN ONE ITEM PER DELIVERY

We then enter these details into our database using the delivery
address and the goods they need and the quanties

then when we send these out when we allocate a driver who will be delivering
the deliveries and mark them as completed with a yes no field.

Here are the fields i will be using so might need rearranging a bit!


DELIVERY DETAILS
JobID
Consignee
Address
TelephoneNumber

ORDER DETAILS
JobID
OrderDate
DeliveryDate
StockCodeID
Description
Quantity
ShipComplete Yes/No

PRODUCTS
StockCodeID
Description Of Goods

DRIVER
JobID
Driver Name
Company Name
MobileNumber
Delivery Charge


THANKS IN ADVANCE
SIMON

 

[ezfriend]

What's the question?

 

[hullstorage]

What's the question?

have now sorted out all the field required and need to see what needs to be where i.e. tables and relationships