I am building a Locations function for a bank. In the ItemTemplate I have listed all the branch locations, and the DetailTemplate displays specific information about the selected location.

However, in the DetailsTemplate I also need to list information for the location closest to the current one.

I have added a column to the database that stores the closest location's ID.

How can I use this field (e.g. nearestLocationID = 1) to get data from that specific row in the database? At the moment I can only retrieve information from the current row in the Details template?