Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / December 2003

Tip: Looking for answers? Try searching our database.

Need to designate "same household" for contacts

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
April K - 15 Dec 2003 19:17 GMT
Here is my question:

I have a main table that contains the complete contact
information for each stakeholder.  This includes: name,
address, city, state, zip, phone, etc... What I need to
find is an easy way of designating when more than one
person is from the same household or organization.  

For instance Jeff Jones and Tom Smith might both reside at
1234 Lincoln Way, No Where, US 55555.   Currently, they
would both be entered into the database as individual
records.  This generally works well for large companys &
organziations when recieving separate letters, invites,
notices, but for a property owner of a residence or small
business, several pieces of the same mail can be very
annoying.

What I would like to do is find a way to designate them as
being in the same household so that when we send out a
newsletter or invite - only one is sent to the address,
but is addressed to all of the household members.  Any
thoughts....

Thanks in advance for your help.

~April

Sorry - I forgot one piece of info.  Each stakeholder has
already been designated by "group type" - for example:  US
Senator = USEN, Residential Property Owner = RPO, and so
on.  Only RPO and a few other group types would fall into
what I am trying to do.  Everyone else would still recieve
individual mailings...
Adrian Jansen - 15 Dec 2003 22:57 GMT
One way to solve this would be to have separate tables for the Contacts and
the Addresses.  Then a junction table with entries for the ContactID and
AddressID.  The you can put as many Contacts at one Address as you like just
by making multiple entries in the junction table.  And of course you can
handle the reverse case where one Contact can have multiple Addresses -
Home, work etc.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
> Here is my question:
>
[quoted text clipped - 29 lines]
> what I am trying to do.  Everyone else would still recieve
> individual mailings...
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.