I have a Smart Object that is retrieving a set of data from a SQL table. This table has a 1 to many relationship with another table, which also has a 1 to many relationship with another table.

I'm not sure what is the best way of being able to pull back all this information. I want to be able to select a row from the first table, and retrieve all the records from the sub table that are related, and also all their related records... Are SmartObjects still the way to go?