[AccessD] Match the spouse

Ervin Brindza viner at EUnet.yu
Thu Mar 31 02:33:04 CST 2005


Many thanks for all the replies!
Ervin
----- Original Message -----
From: "Jim Hewson" <JHewson at karta.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Wednesday, March 30, 2005 3:12 PM
Subject: RE: [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
> --
> 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