#75 Limitation in using foreign keys

open
nobody
None
5
2011-09-02
2011-09-02
Anonymous
No

There is a limitation in using foreign keys: One column can be part of ONLY one foreign key.
I.e. It is not possible to use one column for two foreign keys.

Example:
Suppose we want to create an n:m relation table between two database tables.
Both of the tables have comlex primary keys with at least one common colum.
In the relation table we normally do not want to have this column twice.
So we would like to use this common column as part of both foreign keys.
This is not possible in ER Master.

To dissolve this limitation would be really great, because this case is not so rare.
Thanks very much

Discussion

  •  
    Attachments
  • Kevin Gurney
    Kevin Gurney
    2011-11-23

    +1 Same issue.
    Would be good to see this implemented