Re: Relationships with same primary key but multiple different foreign keys

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Allen Myers (rocketjumped_at_hotmail.com)
Date: 04/12/04 

Date: Mon, 12 Apr 2004 08:43:20 -0700

"PierreCampe" <Pierre.Campe@pandora.be> wrote in message
news:uoqhiyPHEHA.640@TK2MSFTNGP10.phx.gbl...
> Allen
> to tell the truth i dont quete understand what you mean
> however i think it is the following
> if you create a many to many relationship of the personel table with
itself
> by means of the YearlyReviews table then you can enforce referential
> integrity
> in as far as the db will make it impossible to have an YearlyReviews entry
> with manager or employee field that is not in table personel

Pierre, you have a direct way with words. Yes, thats essentially what I was
trying to explain. Thanks again for your help and insight into this aspect
of databases. Much appreciated!!