[AccessD] Match the spouse

For our social service applications (food shelves, family violence and
the like), we use a household table which includes the address, and a
person table including a FK to HouseholdID.

This allows as many people as they like to live at the same address,
without anyone having to ask any awkward questions.  

Liz 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey
Sent: Wednesday, March 30, 2005 8:15 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Match the spouse

Assuming, that is, a monogamous workforce.

--
Andy Lacey
http://www.minstersystems.co.uk



--------- Original Message --------
From: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
To: 'Access Developers discussion and problem solving'
<accessd at databaseadvisors.com>
Subject: RE: [AccessD] Match the spouse
Date: 30/03/05 13:46

>
> So, the problem is which employee is the family anchor, right?
>
> Self join to the spouse pk. Lots of records will be empty of course,
but
the
> alternative would be a new table and I'm not sure that's really
necessary.
>
> Susan H.
>
> Cross posted
> Hi,
> I have to modify the design of my human resources database (workers in
the
> factory) to add a feature to match the spouse if the spouse works here
too.
> And it would be great too to avoid duplicationg the kids records,
which
are
> in separate table in one to many relation with the main table.
> Are there any suggestions?
> Many TIA,
>         Ervin
> --
> 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
>
>
>
>
>
>

________________________________________________
Message sent using UebiMiau 2.7.2

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