I need help with complex relationships and queries using DataMapper

[eluser]qureshi[/eluser]
Hi,

First off: Thanks so much for CodeIgniter. To me it is pure beauty in action. I'm a newbie PHP programmer, but with CodeIgniter I feel like I have PHP superpowers!

I'm building a Quran studytool, and I've run in to some problems. I would really appreciate some help.

In my database, a user can create categories. So we have these tables: users, categories and categories_users.

The categories in turn can have verses. The tables are: verses and categories_verses.

The verses themselves have many translations. So we get: translations and translations_verses.

As you see, starting from a category and getting to the translations requires using two relations: categories_verses and then translations_verses.

But how do I do this with CodeIgniter/DataMapper? I know how to use one relation, but don't get how to use two sequentially.

Thanks for reading.

Regards,

Nadeem Qureshi