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]