relate using a candidate key?

["Mcgough, Brian Joseph" <bm...@indiana.edu>]

Hello,

 

We have a situation where we have a table that has a primary key, but we
are adding an additional "candidate" key that will always be unique and
mandatory we would like to be able to use to define these relationships
and not the primary key.

 

Is there any way to do this?

 

Thanks,

 

Brian McGough

Indiana University