Using Toad on a model for SQL 2008. I have an auto-incrementing column assigned as my primary key. My alternate key is actually the column I want to use in the foreign key relationship but each time I draw the relationship, it uses the primary key. Does the parent side of a foreign key always have to be the primary key?
It’s possible to assign alternate key as the parent.
i’m having trouble getting the parent side to use an alternate key. can anyone help me with the process?