To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=57006
Issue #:|57006
Summary:|Cannot user Relationship Editor to make 2 seperate FK
|relationsips to the same column
Component:|Database access
Version:|OOo 2.0
Platform:|All
URL:|
OS/Version:|Windows XP
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|DEFECT
Priority:|P3
Subcomponent:|none
Assigned to:|dbaneedsconfirm
Reported by:|atjensen
------- Additional comments from [EMAIL PROTECTED] Sun Oct 30 19:03:58 -0700
2005 -------
Base has a bug where you cannot do this in the GUI relationship designer.
However you can do it via DDL commands.
I created a databae with two tables:
Traders ( TraderID IDENTITY, Name Varchar(50) )
Transactions( TransactionID IDENTITY, SellerID Integer NOT NULL, BuyerID Integer
NOT NULL)
I then opened the SQL window and entered the follwoing DDL commands:
ALTER TABLE "Transactions" ADD FOREIGN KEY ("SellersID") REFERENCES "Traders"
("TraderID")
ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE "Transactions" ADD FOREIGN KEY ("BuyerID") REFERENCES "Traders"
("TraderID")
ON DELETE CASCADE ON UPDATE CASCADE;
Grab the odb file I will attach. Use the relationship editor to remove the two
FK relationships and then attempt to recreate them uising the GUI tool. Can't
do it.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
