<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED FIXED - Issue on setting up Relationship"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=112722#c8">Comment # 8</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED FIXED - Issue on setting up Relationship"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=112722">bug 112722</a>
from <span class="vcard"><a class="email" href="mailto:robert@familiegrosskopf.de" title="robert@familiegrosskopf.de">robert@familiegrosskopf.de</a>
</span></b>
<pre>(In reply to perie_gut from <a href="show_bug.cgi?id=112722#c6">comment #6</a>)
<span class="quote">> As of the latest version, I still was not able to saved the relationship for
> the following:
>
> ContractDetails.BargainPurchaseOptionType =
> BargainPurchaseOption.BargainPurchaseOption
>
> *also for the BargainRenewalOption
>
> and I have tried to manually create the relationship (from insert >
> relationship) and got the following error
>
> SQL Status: S0011
> Error code: -170
>
> Primary or unique constraint required on main table: "BargainRenewalOption"
> in statement [ALTER TABLE "ContractDetails" ADD FOREIGN KEY
> ("BargainRenewalOption") REFERENCES "BargainRenewalOption"
> ("BargainRenewalOption")]</span >
Error appears, because "BargainRenewalOption" isn't unique. There are two
primary-keys in the table. So how should the database be able to know which of
the different rows of "BargainRenewalOption" will be the right?</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>