Foreign Key Constraint

I need to make a FK constraint, but it is against a table where the column is not a PK, can this be done?

Table1:
  Customer ID \ Composite Primary Key
  Portfolio ID / Composite Primary Key

Table 2:
  Portfolio ID: Non unique and must exist in Table 1

Thanks! Received on Fri Jul 15 2011 - 08:44:41 CDT