[AccessD] This seems to get me often

If I understand the purpose of your database correctly, Susan, then that's 
how I would do it.  I agree with you - if you are tracking donors, then orgs 
and individuals in the same table is not denormalised.  And if you need to 
also identify the connections between individuals and organisations, or 
between individuals and other individuals, or between organisations, then 
use a sub-typing model as mentioned by Jack.

Regards
Steve


-----Original Message----- 
From: Susan Harkins
Sent: Wednesday, December 24, 2014 1:48 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] This seems to get me often

A donor can be an individual or an organization -- they're all donors.
Donor is the entity, the name and type of donor all belong to donor. Right?

Susan H.

On Tue, Dec 23, 2014 at 7:36 PM, Charlotte Foust <charlotte.foust at gmail.com>
wrote:

> ​Not without denormalizing the table.
>
> Charlotte>
> On Tue, Dec 23, 2014 at 4:32 PM, Susan Harkins <ssharkins at gmail.com>
> wrote:
>
> > Is there anyway to have orgs and individuals in the same table?
>
>