To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=104960
Issue #|104960
Summary|n-n relations needed in database gui
Component|Database access
Version|OOo 3.1
Platform|PC
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|ENHANCEMENT
Priority|P3
Subcomponent|none
Assigned to|dbaneedsconfirm
Reported by|rboileau
------- Additional comments from rboil...@openoffice.org Thu Sep 10 16:19:05
+0000 2009 -------
In OpenOffice Base, the gui does not permit n-n relations between tables.
For example, given a database with a table of Products and a table of Users:
a product may have more than 1 user
a user may have more than 1 product
Trying to build relations between the tables:
connecting UserID in User table to UsersList in Products table is only 1-n
then connecting ProdID in product table to ProdList in Users table
results in Error:
Primary or unique constraint required on main table: "Users" in statement [ALTER
TABLE "Products" ADD FOREIGN KEY ("UserList", "ProdID") REFERENCES "Users"
("UserID","ProdList")]
(UserList and ProdList have not been populated yet.)
Is this the proper approach for tables with multi-cross-references?
---------------------------------------------------------------------
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: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
