It's best practice to declare the foreign keys according to functional dependencies. E.g. if your other table is about salespeople, then its foreign key should refer to Salespeople.

REDMOND, Wash., April 10, 2001 — Built with security as a top consideration, Microsoft® SQL Server™ 2000 allows administrators to configure database security flexibly, and supports the U.S. government ...