For new Visual Studio LightSwitch questions,
It is recommended that you use the official Visual Studio LightSwitch Forums at:

    I have a screen with several autocomplete boxes populated by queries and set up as 1 to many relationships. The queries and autocomplete boxes work as intended. I cannot, however, figure out how to access the other data in the query when the user selects it. 
    For instance, if a user selects a customer and that customer has several ship to addresses which are popluated in an autocomplete box based on the selected customer. The query works fine..the auto box shows the customers ship to names. But I need to popluate the screen with the acutal address data, i.e., address, city, state when the user changes the ship to.
    Everything I've done through code only points to the first record in the query and not the one selected. It would seem that dragging the field onto the screen from the query would work, but it does not. I've used code in the property change event equivalent to Me.ScreenCityProperty=Me.query.City. This always points to the first record in the query and never for the selecteditem. This seems so simple to do.

Thanks in advance,

Rhino

You can do this using Linq. Below is the pseudo code to get the idea:

Dim Addreses = (from s in where s.id=).firstordefault
if not isnothing(adresses) then
address = addresses.address
city = addresses.city
end if

Thanks for your response hgminerva. I still think in terms of pulling data from a table that all the row data would be pulled in the query and accessable on from the screen. Guess that is not the case.