Devart Forums

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

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.