• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2244
  • Last Modified:

Visio error "forward and inverse verb phrases"

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.
Thanks!
Rich
0
RichardFox
Asked:
RichardFox
  • 2
  • 2
1 Solution
 
Arthur_WoodCommented:
change teh verb phrases for the two relationships "DELIVERS TO" and "SELLS TO" for example.  That should resolve the 'error'
0
 
RichardFoxAuthor Commented:
Yeah, I know. But I have about 130 verb phrases to change, which is extremely unpleasant to do, without any benefit in my physical database. That's why I want to shut this error check OFF!!
0
 
Arthur_WoodCommented:
you cannot turn the error check off.  YOu either correct the Verb phrases, or delete them completely.  Those are the only possibilities.

AW
0
 
RichardFoxAuthor Commented:
OK (sob!)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now