Can someone help me. I’m trying to create a compound foreign key in Toad Data Modeller.
We need to create a relationship between an account number/sub account number on one table with a single field containg both on another table thus:
TAB1.SUB_ACC_NO = TAB2.ACCNO | |LOAN_NO
ie 12345601 = 123456 || 01
In TDM I only seem to be able to select one field on each side of the relationship even though the help file says that compound keys are possible:
“In Toad Data Modeler, you can control your foreign keys. Foreign keys mapping feature allows you to create Compound Keys, use existing keys etc.”
Can someone advise if and how this is possible?