Issue 104960 - n-n relations needed in database gui
Summary: n-n relations needed in database gui
Status: UNCONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 3.1
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-09-10 17:19 UTC by rboileau
Modified: 2013-02-07 22:36 UTC (History)
2 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
attempt to bilaterally cross-reference 2 tables (5.41 KB, text/plain)
2009-09-10 17:20 UTC, rboileau 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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