DataMapper ORM v1.8.0

[eluser]WanWizard[/eluser]
[quote author="ipsod" date="1296837630"]Transactions have two Accounts - to and from. Accounts, though, I don't want to have Incomes and Expenses separately, just Transactions, so that I can do $a->transactions->get_iterated(); and have all the transactions ordered by date, but I can't seem to get them set up this way.[/quote]
If you have multiple relationships between two tables, the only way to define them is using advanced relationships. If you use an object of an account to get transactions, you need to specify which relation you want to use (to or from), you can't use both. You can work around that by using

Code:

$transactions->where_related('from', $some_id)->or_where_related('to', $some_id)->get_iterated();