[AccessD] Match the spouse

I think I would add a table.
A M-M to the employees and kids tables.

tblEmployees
EmployeeID (PK)
EmployeeID (FK) reference back to same table for Spouse
Name of Employee

tblEmployeeKids
EmployeeID (FK)
KidsID (FK)

tblKids
KidsID (PK)

When looking at an employee's record, the spouse and kids are visible.

Jim
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Ervin Brindza
Sent: Wednesday, March 30, 2005 6: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