[AccessD] This seems to get me often

Tina Norris Fields tinanfields at torchlake.com
Wed Dec 24 12:19:58 CST 2014


Rocky,
I love your encouragement.  Thanks!
TNF

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

On 12/23/2014 10:08 PM, Rocky Smolin wrote:
> Normalization is for weenies!  You go girl.  Just leave that FK blank!  A
> good program is one that works.
>
> R
>   
>
> -----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 4:11 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] This seems to get me often
>
> Yes, that's what I've done.  What's troubling me is that not every donation
> will have both FKs filled - as when the donor is just an individual, not
> associated with an organization on record.  something feels wrong (not
> normalized) about that setup, but I don't see how to normalize it.
>
> Would you use the same principle for other similar setups, such as the
> different associations for phones?  For instance, the household has a land
> line, and the several members of the household carry cell phones.
> The table of phone numbers will have an identifier for the type of phone and
> an FK for either the household or the individual.
>
> Thanks for your ideas.
>
> TNF
>
> Tina Norris Fields
> tinanfields-at-torchlake-dot-com
> 231-322-2787
>
> On 12/23/2014 6:15 PM, Rocky Smolin wrote:
>> 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
>>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



More information about the AccessD mailing list