Datamapper advanced relationship question

[eluser]WanWizard[/eluser]
Just make an ER diagram, showing all the tables, primary and foreign keys, and their relations. On paper of with some tool. I personally use Visio as it is platform agnostic, but you can also use MySQL Workbench.

From there it's pretty easy to define the models and their relationships.

In your code, you can just chain the relations, it doesn't matter how deep:

Code:

$grandparent->parent->child->grandchild->where('field', 'value')->get();