Common issue understanding the ways of the Foreign Key.
Every now and then if I haven't done one in months... I gotta go look!
Now which way does this thing go? Which is the foreign and which is the primary?
Seems like that concept tripped me up when I was starting.
http://msdn.microsoft.com/en-us/library/aa933117(SQL.80).aspx
Todd Carrier
MCITP - Database Administrator (SQL 2008)
MCSE: Data Platform (SQL 2012)