Problems with foreign keys. Cannot create 1 to many relation

Ril · Post by **Ril** » Tue 09 Jun 2009 15:06

I cannot seem to create a 1 to many relationship using the DBForge Database Diagrams. Please tell me what I am missing. I tried several times, but I end of with 1 to 1...0 relationships when I want 1 to 1...n relationships.

Similarly, I tried doing the same thing by creating the foreign keys directly, but it still does not show up as a 1.. to many relation.

Thanks

Duke · Post by **Duke** » Wed 10 Jun 2009 07:51

Relation 1 to 0...1 is show on database diagram when field in child table has unique index. If you need 1 to 1...n relation child field must have only not null constraint.
Please make sure that child table does not have unique index on field that participates in foreign key.
For more information please refer to product documentation.

P.S.
If you notice incorrect behavior of our product feel free to contact us.