Datamapper ORM Multi-tabel Relationship Halp!

[eluser]Genki1[/eluser]
Okay, I get it that multi-relationships are not supported and I'm thinking about your answer. However, your answer changed my scenario and I want to make sure I implement it correctly (to avoid banging my head on the table for another 5 hours :-) )

What I want is this: (item in red is an edit to your answer, above)

User -> has many -> Purchases
Templates -> has many -> Purchases
Options -> has many -> Purchases
Purchases -> has one -> User
Purchases -> has one -> Template
Purchases -> has many -> Options

So, will this work...

Code:

$user = new User(1);

// get all this user's purchases
$user->purchase->get();

// get info about a specific purchase
$user->purchase->where('template_id', 16)->get();

// get all options for this purchase
$purchase = new Purchase(3);
$purchase->option->get();

...using this table?

join_table: "purchases"

Code:

[id] [user_id] [template_id] [option_id] [value_for_this_template_option]
  1       1         1             1        Some data
  2       1         1             3        more stuff
  3       1         2             1        Maybe my name here
  4       1         2             5        contact info
  5       2         1             1        Yet more user data