Hello All,

Quick and dirty, this is what I would like to do:

GrandParent is one to many with Parent is one to many with Child.

Child has parent property to Parent table.
Parent has children property mapped to Child table and parent property linked to GrandParent table
GrandParent has children property mapped to Parent table.

All easy so far. Now for the tricky part.

I want to have a grandChildren property on GrandParent, mapped to Child table, containing all children (in Child table) of all children of the GrandParent (from Parent table).

I'm using hibernate within seam, so the property approach is what I'm looking for, I know how to do it with a query (at least I'm fairly certain I can). Is it possible to map a query (native or HSQL) to a property (other than @Formula which apparently is only for primitive values)?

Thanks for the help,
-DS