hullstorage
Registered User.
- Local time
- Today, 18:04
- Joined
- Jul 18, 2007
- Messages
- 213
I starting a new project and need a bit of advice.
I have 3 tables as follows:
TblCustomers
TblContacts
TblWarehouse
TblCustomer has all the head office details entered.
TblContacts has contact names and telephone numbers as there is sometime more than one contact person and telephone number.
TblWarehouse has there warehouse details stored, but is the same if they do not have a warehouse address
Can somebody briefly tell me what fields i should use and where, also how to join them
Please see picture for better idea attached
many thanks
I have 3 tables as follows:
TblCustomers
TblContacts
TblWarehouse
TblCustomer has all the head office details entered.
TblContacts has contact names and telephone numbers as there is sometime more than one contact person and telephone number.
TblWarehouse has there warehouse details stored, but is the same if they do not have a warehouse address
Can somebody briefly tell me what fields i should use and where, also how to join them
Please see picture for better idea attached
many thanks