How to make 2FK going to the same parent?

[ETN]

Hi,

I have a little problem making 2FK to the same parent.

Here is an example that is not identical but look like my situation:

- I have a table LOCATION, that contain
(ID_LOC,NAME,CITY,...)

- I have a table INDIVIDUAL (ID_IND,NAME,PHONE,...)

Then I have my table INDIVIDUAL_JOB (ID_IND, SALARY, HOME_LOC, JOB_LOC)

HOME_LOC and JOB_LOC are foreign keys that should get the information from the table LOCATION.

I can create my relation in Visio but when I error check my model or try to generate it does not let me:

error L3020: 'CIU_CF742_FK1' : Foreign key relationship has same parent and child tables as CIU_CF742_FK2, but does not have different forward and inverse verb phrases.

What can I do ?

 

[ETN]

Found the answer:

On the Name tab of the relationship in the Database Properties Window, be sure to change the inverse phrase from "is of" to "is XXX of" where XXX is the name of the column in the FK table. For example, for FK1 below, I changed the phrase to "is HOME_LOC of" and for FK2, I changed the phrase to "is JOB_LOC of"