[AccessD] This seems to get me often

I make the individual table your primary table with all the contact info,
etc.  And a field which would be an FK to the Organization table.  That way
many individuals could belong to an organization.  For the donation record
I'd put two FKs, one to the individual, one to the organization.  

hth

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tina Norris
Fields
Sent: Tuesday, December 23, 2014 3:05 PM
To: DatabaseAdvisors-Access
Subject: [AccessD] This seems to get me often

Hi,

I do keep having this sort of problem to solve.  An example would be that a
donor could be an individual or an organization.  So, a donation record
might have an individual ID as an FK or it might have an organization ID as
an FK.  I'm uncomfortable with setting up a table where one of two FKs will
be blank.  Another example would be that a client of a law firm could be an
individual or an organization.  Another example would be that a telephone
could be associated with an individual, or a household, or an organization.
What is the logical way to handle these?  What am I not seeing?

Thanks for your guidance.

TNF

--
Tina Norris Fields
tinanfields-at-torchlake-dot-com
231-322-2787

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com