We need some help witha work around with pulling a relationship of a relationship since there is not a way to do it currently in RE.

We are a Greek Organization and we are often asked to pull School name of chapter officiers, for example. The Chapter Officier has an indivigual relationship to the Chapter of Chapter President. We currently do not keep track indivigually of where chapter presidents go to school, but it is assumed that they would attend the school of the chapter that they are president of.

The chapter (an organization) has an organizational relationship of Chapter to the University. We need to pull the Chapter President's Chapter's School.

I'd love to hear any idea you may have of how we can find a work around or something we can implement. The ideas we've come up with are not very 'data integrity' solid (like adding in the chapter's organizational record who is the Chapter President and doing that everytime we have a change in office; with 200+ chapters changing every 6 months, it makes us a little nervous).

Thanks!

 PJS