[AccessD] Match the spouse

This requires a many to many table

Employeeid
RelationID
RelationshipTypeID

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Ervin Brindza
Sent: Wednesday, March 30, 2005 7:46 AM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Match the spouse


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