Issue 104960

Summary: n-n relations needed in database gui
Product: Base Reporter: rboileau <renee.boileau>
Component: codeAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: helge.kraak, issues
Version: OOo 3.1   
Target Milestone: ---   
Hardware: PC   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
attempt to bilaterally cross-reference 2 tables none

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?
Comment 1 rboileau 2009-09-10 17:20:24 UTC
Created attachment 64675 [details]
attempt to bilaterally cross-reference 2 tables