Issue 51787 - Problems with creating multiple relations between tables
Summary: Problems with creating multiple relations between tables
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.0 Beta
Hardware: All All
: P3 Trivial with 11 votes (vote)
Target Milestone: ---
Assignee: Frank Schönheit
QA Contact: issues@dba
Depends on:
Reported: 2005-07-11 03:43 UTC by vreid47362
Modified: 2013-08-07 15:45 UTC (History)
3 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description vreid47362 2005-07-11 03:43:36 UTC
In OpenOffice Base it seems impossible to create relations between the same
field in one table with multiple fields in a second table.  Please see the
attached OpenOffice forum url for the question that I posted to the group there.

Here is a summary of what Base should do.  I have 2 tables people and issues

the people table has a field that needs to be set as the foreign key
on 2 field in the second table.  In the second table, needs to be a
foreign  key with a 1 to n relationship to issues.reportedby and issues.assignedto.

Unfortunately, although this very common type of relationship type is possible
using the SQL part of OpenOffice Base, the qui seems quite unable to accomplish

Please create a way to create these types of relationships with OpenOffice Base.
 It will go a long way to making the software more usable.
Comment 1 bobharvey 2005-07-30 06:12:26 UTC
*** Issue 51787 has been confirmed by votes. ***
Comment 2 marc.neumann 2005-10-31 14:48:48 UTC

I can confirm this with a hsql database.

When you select 2 field in the  relation  properties the OK button is greyed out.

confirm, reassign to the right developer and set target.

Bye Marc
Comment 3 alex.thurgood 2006-05-16 09:42:10 UTC
This was supposed to have been fixed by a cws, but I don't recall which one, nor
whether it was integrated.

Comment 4 vreid47362 2006-05-18 07:59:46 UTC
I've been looking at build 169, and I can't seem to make the base relationship
gui create a relationship with more than than 1 field from a table.  For
example, I can't join field 1 in table A to both field 1 and field 2 in a table
B.  I also cannot get the gui to join field 1 in table A to field 1 in Table B
while simultaneously joining field 2 in Table A to field 2 in Table B.  I also
cannot get the gui to join a field to another field in the same table.

To sum it up, in build 169 the base relationship tool still seems limited to 1
relationship per table with no more than 1 field involved from each table. 
Build 169 also does not appear to support self-joining relationships using the
relationship tool.
Comment 5 bobharvey 2007-03-23 23:40:55 UTC
Any progress on this one?
Comment 6 Regina Henschel 2007-04-15 11:27:05 UTC
Isn't it the same problem as in issue 56898?

vreid47362 remarks, that a self-joining relationships is not possible with the
GUI. Is this a different issue?
Comment 7 cjbrooker 2008-04-04 12:31:11 UTC
I believe that this may now be fixed in 2.4 by issue 56898.

Perhaps the reporter could confirm this.
Comment 8 vreid47362 2008-04-04 17:48:53 UTC
In OpenOffice 2.4, it appears that I can successfully create relations between a
single field in one table and multiple fields in a second table using the
relations gui.  I am also able to create relations between a single field in one
table and a single field in several other tables using the relations gui. 
Thanks for the new functionality!

I am still not able to create a relationship between two fields in the same
table (eg. employeeid and supervisorid in the same table).  I am also not able
to create a table alias in the relations gui to work around this limitation.

Comment 9 Mechtilde 2008-04-05 15:16:15 UTC
as the OP wrote.

the issues is fixed with issue 56898 and verified

so I set the flags.

Comment 10 Mechtilde 2008-04-05 15:17:18 UTC
-> verified
Comment 11 Mechtilde 2008-04-05 15:17:43 UTC
-> closed