[Libreoffice-bugs] [Bug 112722] Issue on setting up Relationship

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=112722

--- Comment #8 from robert at familiegrosskopf.de ---
(In reply to perie_gut from comment #6)
> 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")]

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?

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171211/3c4edaab/attachment.html>