Creating multiple foreign key associations

[skiwi]

I have had a lot of problem in this area when doing some physical data modelling. In particular with multiple foreign keys.

See also
http://www.sparxsystems.com/cgi-bin/yabb/YaBB.cgi?num=1263179990
http://www.sparxsystems.com/cgi-bin/yabb/YaBB.cgi?num=1263306644
http://www.sparxsystems.com/cgi-bin/yabb/YaBB.cgi?num=1260782579

[ScorpioTiger]

Hi Folks,

Ok, I've done some more playing. I've just been able to successfully add two foreign key constraints. The secret was in ensuring that you don't accept the default name for the constraint. If you create one constraint and leave the default name, as soon as you create a second constraint, the name will be the same as the first one and they're treated as one and the same because they have the same name...and changing the name at that point doesn't help...changing the attributes used for the constraint on one changes the constraint on both.

There also seems to be an artifact left after you delete an association from the model. This prevents you from creating a constraint, deleting it, and then creating a constraint with the same name as the one you've just deleted.

Pretty crappy bugs..! And they shouldn't be difficult to fix.

Thanks for everyones input and I hope my experience helps in defining a work around.

Scorpio...

[skiwi]

Good work. I hope you have formally reported the bugs, and we see them fixed.

[Paolo F Cantoni]

[size=18]...[/size]
Pretty crappy bugs..! And they shouldn't be difficult to fix.
[size=18]...[/size]

That's what I thought 6 years ago for some of the bugs I reported then...

They're STILL here!

Please submit Registered Bug Reports or Bug Reports and tell us the names,
leaving a note here to say you've done it.
We users can then vote for them using a Registered Bug Report or Bug Report with the same name[/color]

Paolo

[ScorpioTiger]

Good work. I hope you have formally reported the bugs, and we see them fixed.

Done.