How to re-use a ForeignKey Link name property

Discussions about database modeling product Cameo Data Modeler functionalities

Moderator: Moderators

How to re-use a ForeignKey Link name property

Postby andrew.mcgimpsey@amt-sybex.com » Tue Oct 18, 2016 5:13 am

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.
You do not have the required permissions to view the files attached to this post.
andrew.mcgimpsey@amt-sybex.com
Forum Newbie
Forum Newbie
 
Posts: 3
Posts Rating:0
Joined: Wed Sep 28, 2016 7:43 am

Re: How to re-use a ForeignKey Link name property

Postby gedkvi » Thu Oct 20, 2016 9:03 am

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
You do not have the required permissions to view the files attached to this post.
gedkvi
Customer Support
Customer Support
 
Posts: 45
Posts Rating:7
Joined: Wed Sep 16, 2015 11:25 am

Re: How to re-use a ForeignKey Link name property

Postby andrew.mcgimpsey@amt-sybex.com » Mon Oct 24, 2016 3:59 am

Hi Support,

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

Thanks for your response.
andrew.mcgimpsey@amt-sybex.com
Forum Newbie
Forum Newbie
 
Posts: 3
Posts Rating:0
Joined: Wed Sep 28, 2016 7:43 am


Return to Cameo Data Modeler

Who is online

Users browsing this forum: No registered users and 0 guests