Query with also parent object

Topics: Customizing Orchard
Jan 31, 2014 at 12:27 PM
Hi
I need help in starting work with Orchard.
I'm a asp.net mvc web developer also.
I need to make a site for a customer, but I have difficult to understand the right way to do this:

I have two item:

Destination: that contains this information: Title, Description, Pictures
Travel: that contains this information: DestinationRef, DateFrom, DateTo, Price ecc.

so for each destination there will be more than one travel associated.

In my site I have to show all destination with the next near travel (the most near to today) indicated.



I start to created the custom content types Destination and Travel, I create some content of each type.


I want to show in a page all the destination with also the information of the next near travel. How can I do it? Using the query I can retrieve all the destination easily, but I don't find the way to add also the travel information.
Or i can retrieve all the travel that i need (only one for each destination), but How can I display also the parent destination information?

thank you
Luca