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.
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