Forums / CodePlant Designer Technical Issues
multiple FK and "fishhook" FK
Posted on 2/28/2011 12:01:24 PM by mail@matej.us

Hi guys.

two more questions:

How can i manage multiple FK between the same tables.

  • When I put second reference then the lines are identical. Only reference name can be moved but i don't see two lines and it's confuse for me.
  • Both references are joined to the "Column1". i cannot change referenced colum in design mode nor change it in table definition.

Is it possible to create reference to the same table?

alter table aaa add constraint fkaaa foreign key (k) references aaa(i)

 

many thanks for answer or change

Matej