Re: Company and multiple addresses DB design

Move the addresses to a address separate address table and relate to
the company so that company has multiple addresses?
Move the addresses to a address separate address table and relate to
the contact?

I would make a table for your companies and if a company has more then
one address just put a new record with the same name. You can specify
eg. Company Name Head Office, Company Name Division... Each company
has 1 or many contacts. Open your form starting with the Companies and
add along a subform the related contacts. Address fields and Companies
should belong together.

I discovered also a problem with my design of Companies and Contacts
and perhaps it could also happens to you. I had companies and many
contacts related to the company. But the problem I discoverd was that
some contacts belong to more then one companies. e.g. some contacts
where CEO of more then one company. Here I needed to change the
relationsship with a between table (many to many).

just some ideas,
patrick.

.

Relevant Pages

  • Re: Spread table.
    ... > multiple files unless each file is on a separate drive array. ... > Raid 10 and with multiple processors Sql Server can use multiple threads to ...
    (microsoft.public.sqlserver.clients)
  • Re: Multiple address mail merge problems
    ... they are imported to Entourage with on ... Entourage doesn't break this into two separate addresses but tries to ... Outlook had a setting where you could change multiple ... problem when creating multiple email messages, ...
    (microsoft.public.mac.office.entourage)
  • Re: Having mega-problems with importation of 20,000-line text file
    ... FTP'd from a UNIX platform to windows via FTP ... multiple lines in them separated by CRLF's. ... be a separate record. ... in the problematic rows than in the other lines (&H0d ...
    (comp.databases.ms-access)
  • Re: Trying to wrap my head around splitting up & combining tables
    ... Address tables are a thorny problem in normalization terms. ... multiple times can introduce redundancy with all the problems that entails. ... Both Michigan and Minnesota have a city called Grand ... One step down from full normalization is to just have separate City, State, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Exzporting Contacts and Pasting Contacts Into Excel
    ... > multiple address lines. ... > during the OL2K to Excel 2K process, ... > extra lines get dropped into separate Excel fields? ... >>properly to enable a "multi-line" field to be displayed ...
    (microsoft.public.outlook.contacts)