I have a complex type that I wanted to talk through on the forum before I figured it all out.
I have a course, material, and menumapping. Fields in menumapping table are as follows:
id
materialID
courseID
parent
Basically, I need a group of root menu items to be made from Materials depending upon the course selected, then each of those materials maps out other sub menu items from other materials. So a material has a list of other materials (which also must all comply to the courseID given). This pattern continues until there are no more materials with parent items attached to them.
So for instance, if we were checking courseID 2 - it would find the root elements, and then map out more materials based on their parent. I got this mapping to work when I had it on OneToMany relationship with just a Material and Course classes, but then it was tied to one course (because the Material class only had a field for one Course and one Parent ) I need there to be many materials mapped to many different courses?
I found this:
http://tadtech.blogspot.com/2007/09/hib ... in_03.html
which is close to what I need, but it does not seem to build out items to the same item - like Materials to Materials which is my case. Any help is appreciated.