I forgot to ask if this applies to all versions of SQL Server (higher than 2000). So, to restate the question, can a foreign key be declared in a child...

Thanks so much guys. I appreciate your responses!

I'm with ya too. I wish I could find a part-time, or even telecommute, DBA position. Maybe someone should start a job posting site called part-time-techie or something.