hullstorage
Registered User.
- Local time
- Today, 00:43
- Joined
- Jul 18, 2007
- Messages
- 213
Hi all,
I am creating a new project and was wondering how the best way to setup my tables and relationships.
Here are my current tables and contents
CUSTOMERS TABLE
==============
CustomerID
Name
Address
Postcode
Contact
PRODUCTS
==============
ProductID
StockCode
ProductDescription
UnitAmount
ORDERS
==============
OrderID
OrderDate
StockCode
Quantity
ShipDate
CompletedYesNo
Driver
DRIVERS
==============
DriverID
DriverName
Address
MobileNumber
I am creating a new project and was wondering how the best way to setup my tables and relationships.
Here are my current tables and contents
CUSTOMERS TABLE
==============
CustomerID
Name
Address
Postcode
Contact
PRODUCTS
==============
ProductID
StockCode
ProductDescription
UnitAmount
ORDERS
==============
OrderID
OrderDate
StockCode
Quantity
ShipDate
CompletedYesNo
Driver
DRIVERS
==============
DriverID
DriverName
Address
MobileNumber