hullstorage
Registered User.
- Local time
- Today, 14:59
- Joined
- Jul 18, 2007
- Messages
- 213
Hi all, I am about to create a new database and now I have had a bit more practice I was wondering if somebody could give me some advice:
Below are the fields I will be working with and need to know what Tables to create and what relationships.
As i said, I am still fairly new at this so please be easy on me?
Thanks, Simon
JobID
BookingDate
AccountNo
InvoiceNo
InvoiceDate
InvoiceAddress
CollectionAddress
DeliveryAddress
CustomerOrderNo
DeliveryRemarks
InvoiceRemarks
NoItems
Weight
Service
£Cost
Status ( i.e. is invoiced or completed )
Below are the fields I will be working with and need to know what Tables to create and what relationships.
As i said, I am still fairly new at this so please be easy on me?
Thanks, Simon
JobID
BookingDate
AccountNo
InvoiceNo
InvoiceDate
InvoiceAddress
CollectionAddress
DeliveryAddress
CustomerOrderNo
DeliveryRemarks
InvoiceRemarks
NoItems
Weight
Service
£Cost
Status ( i.e. is invoiced or completed )
Last edited: