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
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