Linked Object enhancements
Two improvements to the "Linked Objects" window in visual query designer:
1. Show column name(s) for each associated object.
For example:
[Person]
PersonID
PersonName
MotherID
FatherID
In the "Add Linked Object" window, it would be useful to see
Person (MotherID --> Person.PersonID)
Person (FatherID --> Person.PersonID)
This makes it easier to understand the associations, as well as choose the correct one in the case where you have multiple joins to the same entity.
2. Provide a "multi-select" checkbox on the left side of the list; so, if I have 10 associated tables and I want to join 5 of them, I can just check their boxes rather than having to open the popup 5 times.
1. Show column name(s) for each associated object.
For example:
[Person]
PersonID
PersonName
MotherID
FatherID
In the "Add Linked Object" window, it would be useful to see
Person (MotherID --> Person.PersonID)
Person (FatherID --> Person.PersonID)
This makes it easier to understand the associations, as well as choose the correct one in the case where you have multiple joins to the same entity.
2. Provide a "multi-select" checkbox on the left side of the list; so, if I have 10 associated tables and I want to join 5 of them, I can just check their boxes rather than having to open the popup 5 times.
Thank you for your suggestions.
The first suggestion will be implemented in the next version that will be released next week.
We will consider the second suggestion for implementation in one of the next minor versions.