Hi,

I have a table (lets call it child) with the parent (batch name) in one field as a string.

CHILD_ID, BATCH_NAME, CHILD_NAME, CHILD_DATE

I want to get all distinct values from this table and make a parent object from this, and create child objects from it (so all child rows with the same string value). Does anyone know what is the best way to achieve this in the mapping file?

BATCH (Name, Children)
->CHILD (Batch,Name,Date)

Thanks,
Leen Toelen