Problem: Foreign keys always unique.

[fu...@gmx.net]

I created a one to zero relation in table1 to table2. The problem is now is that the foreign key in table1 is always indexed as unique.

[HOlsen]

When you use a 0..1 to 1 relation between entity 1 and entity 2, you
have said that the relation points to exactly one instance of entity2,
hence the index is unique.

Please read more about relations in the article
http://www.risetobloome.com/Page_1_S.aspx?item=559

Best regards,
RISE to Bloome Software