Rich -
As far as I know, there is no way to disable the Error check - it is a
required part of the 'Generate/Update' process for the DB modeling engine.
Any issues perceived by the Modeling engineer will have to be corrected
before Generate or Update can take place.
However, the warning that you describe seems to indicate that there are two
(or more) relationships represented between two tables. I was able to
create the same message in the following way :
Create a parent table with 2 PK columns
Create a child table with 1 or more PK columns
Add a Relationship shape connecting the Parent to the Child table
This automatically defines a relationship including both parent PK
columns, and creates the appropriate FK columns in the child table
Manually edit the relationship to remove one of the PK-FK associations (PK1)
Add another Relationship connection, which again automatically associates both PK columns
Manually edit the relationship to remove the PK2 association
which each represent (essentially) half of the actual PK/FK matchup that
exists.
When I error check the diagram - I get the same L3020 that you do. The
method that I used was not natural, of course, but I think depending on
your Modeling configuration (database > Modeling > options) it may be that
this arose in some other way. If you dbl-click on one error line in the
output window to view the specific relationship and tables, can you see if
this kind of situation might be present? If so - you should be able to
rebuild the relationship with the current PK/FK matches to test.
I don't know if that helps - since it sounds like you have a pretty complex
model. It would also be interesting to know more about how your model was
built (from scratch, import, Reverse Engineer ?).
