Advice on New project please

hullstorage

Registered User.
Local time
Today, 18:42
Joined
Jul 18, 2007
Messages
213
Hi all

i am starting my new database project and would like to know if somebody can help with the following structure

I would like to create relationships between my tables mainly for invoicing purposes

we run a small transport company and these are the tables that i will be using

the current way we do things as there will be many deliveries for each invoice
is use a dmax function that gives is the current invoice number that has not been posted
and if it is a new set of records then it uses Dmax+1 for that customer

i just wondered the best way of bring all this information together and am i using fields in certain tables that dont need to be there


TblCustomers
CustomerID (primary)
AccountNo
AccountName
Invoice Address ( this is there office address where invoices are sent )
Collection Address ( this is where the warehouse is )

TblDeliveries
JobID (primary)
AccountName
OrderDate
Collection Address ( this would be default of warehouse address )
Delivery Address ( where the goods will be delivered to which vary on a day to day basis )
OrderNo
£Cost

TblInvoice
InvoiceID (primary)
InvoiceNumber
AccountNo
AccountName
InvoiceTotal
InvoiceDate
InvoicePosted ( yes/no with a default of NO )

Many thanks to all
I would not prefer links to other replies as this is quite specific and other times the links
get me all confused
 

Users who are viewing this thread

Back
Top Bottom