This is a followup to www.experts-exchange.com/Databases/Q_20914198.html
I am using Visio to design a database. I have two tables that I am trying to link together, accounts and routes. Now, the accounts table has two entries, sales_route_id, and delivery_route_id. These obviously have route_id in the routes table as foreign keys for both columns. I create two "relationships" in visio, one for each column, and I get "error L3020: routes_accounts_FK1 : Foreign key relationship has same parent and child tables as routes_accounts_FK2, but does not have different forward and inverse verb phrases.
What I want to know is, since this is a Visio-only attribute and does not effect my database at all, is there any way to turn this error check off? If so, I can't find it.