Apache OpenOffice (AOO) Bugzilla – Issue 51787
Problems with creating multiple relations between tables
Last modified: 2013-08-07 15:45:41 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 people.id that needs to be set as the foreign key on 2 field in the second table. In the second table, people.id 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 this. 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.
*** Issue 51787 has been confirmed by votes. ***
Hi, 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
This was supposed to have been fixed by a cws, but I don't recall which one, nor whether it was integrated. Alex
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.
Any progress on this one?
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?
I believe that this may now be fixed in 2.4 by issue 56898. Perhaps the reporter could confirm this.
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.
as the OP wrote. the issues is fixed with issue 56898 and verified so I set the flags.
-> verified
-> closed