Advice on Contacts and Telephone Table and Relationships??? (1 Viewer)

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
 

Attachments

  • Untitled-1.jpg
    Untitled-1.jpg
    40.4 KB · Views: 76

Users who are viewing this thread

Top Bottom