On the Graphical Query editor one should be able to define more than one relationship between two tables without resorting to SQL edition
(Haven't found any similar entry. Sorry if duplicate)
Steps to Reproduce:
1. Design follow schema
Table Comunication (Id,fromPersonId, toPersonId, .....)
We plan to have a query which lists details of the communication event and the names of the persons involved
2. We create a query thru the graphic editor. It only allows the inclusion of persons once; and the definition of only a relationship btw. communication AND person (see query llamadas in the sample database)
3. The query with two relationships is doable and works in plain SQL edition (see query Insql in the sample database); so there is no engine limitation
The GUI query editor should be able to allow the design of such multiple relationship between tables; either inserting n-times a table into the editor area (as other products do) or painting multiple relationship links between two
Drawing multiple relationships is more "natural" but can lead to obscure graphics.
Inserting multiple instances of a table is conceptually "clumsy" but is an easy view
Created attachment 70751 [details]
This is the same issue as mentioned in bug277869, so I closed this one as duplicate.
*** This bug has been marked as a duplicate of bug 277869 ***