Issue 104960 - n-n relations needed in database gui
Summary: n-n relations needed in database gui
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:
Depends on:
Reported: 2009-09-10 17:19 UTC by rboileau
Modified: 2013-02-07 22:36 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

attempt to bilaterally cross-reference 2 tables (5.41 KB, text/plain)
2009-09-10 17:20 UTC, rboileau
no flags Details

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"

(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