one to many / master detail

[Marcel]

what is the best way to renerder master detail in ASP with out repeat visits
to the server and recursive queries.

Class 1
Jim jones
Kathy Pho
Class 2
fred smith
scott free

Ive seen code that uses a variable and a loop but they dont seem to be able
to go one level deap and cant handle more complex information that may
happen after the forinstance

Jims house
house ID
Price
number of bathrooms
Number of bedrooms
Pic1
Pic2
Pic3
Address
Phone number
Sallys house
house ID
Price
number of bathrooms
Number of bedrooms
Pic1
Pic2
Pic3
Pic4
Pic5
Pic6
Address
Phone number

where the pictures are comming form a nither table using the property ID in
the relationship.



thanks


Marcel