[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