How to re-use a ForeignKey Link name property

[andrew.mcgimpsey@amt-sybex.com]

Hi folks,

We are looking to re-use the foreign key names that we have set between tables. The modeller however, will not let us, stating "Conflict with the existing Property ***"

I have attached an example. In the example we have a CarInsuranceApplication entity and Person entity. We have set two relationships between these entities, highlighting who the Proposed Policy Owner will be and the Named Drivers on the application. In the other half of the example, we have a CarInsurancePolicy entity linked to the existing Person entity. This time we have two relationships, one highlighting the Policy Owner and the other should state the Named Drivers of the Policy. When we try to enter and re-use the Property Name "NamedDriver" we get a message stating this is not possible.

Thanks for any replies in advance.

[gedkvi]

Hi,

when you set the name of the relation end, a property gets created and assigned to an element. In your case, the NamedDriver property gets created for element Person. Trying to do the same will result in a warning, because there can not be 2 properties with the same names.
This is the specification dialog for Person:

er.png

Showing that NamedDriver is an attribute of Person.

Are you sure that you are setting the property for the correct relation end?

Sincerely,
No Magic Customer Support

[andrew.mcgimpsey@amt-sybex.com]

Hi Support,

You were right, I had set the relationship name at the wrong end.

Thanks for your response.