Hello,

I need to map a (legacy) table containing repeating groups into a oo-oriented class model.

Consider have following sample table CONTAINER with fields :
ID
Seal1
Seal2
Seal3
Color
Material
...

I want to map this information to 3 classes

class Container
{
String containerID;
}

The repeating group needs to be mapped to a normalized class.

class Seal
{
String containerID;
int sequence; // 1, 2, 3...
String seal;
}

We want to map the other fields The other fi
class OtherInfo
{
String containerID;
String InfoKey; // "Color", "Material", ...
String InfoValue;
}


Can I map a field (eg Seal1) towards 1 instance of a class, and set specific values (1,2, 3) to a property of that instance?

Thanks for any assistance.

Regards,