I noticed that you've opened a support ticket on the same topic, so I'll post my answer here as well:
"The Query Builder
will automatically detect any foreign key relationships between the added tables. However, you are right, if a certain table has more than one foreign key to certain other table, only the first foreign key would be displayed in query designer's Relationships Pane.
I have tested with the AdventureWorks Database. The Sales.SalesOrderHeader
table has two foreign key to Person.Address
table (to BillToAddressID
fields), but there is only one relationship to this table - https://www.screencast.com/t/XoYAejsz4D
(the first one).
Any additional relationships should be added manually (you will need to write them by hand inside the select statement). In this case you could use Manual mode
to specify an join between ShipToAdressID
fields - https://www.screencast.com/t/reMyFA8I
Note that we consider the requirement as a valid feature request. If you wish, you could log this as new feature request in our feedback portal
for voting from other users. The new features implementation in Telerik Reporting is prioritized based on several factors, one of which is user voting."
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Telerik Feedback Portal
and vote to affect the priority of the items