Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||n-n relations needed in database gui|
|Component:||code||Assignee:||AOO issues mailing list <issues>|
|Status:||UNCONFIRMED ---||QA Contact:|
|Issue Type:||ENHANCEMENT||Latest Confirmation in:||---|
Description rboileau 2009-09-10 17:19:05 UTC
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?