[Deprecated] DMZ 1.5.3 (DataMapper OverZealous Edition)

[eluser]mcnux[/eluser]
[quote author="OverZealous" date="1251382009"]
No, I meant what I said. ;-P The name of the relationship defines the column name for in-table foreign keys. In other words, if your relationship looks like this:

Code:

$has_one = array(
    'something' => ...
//   ^^^^^^^^^-- The Relationship Key
);

Then the column name is going to be something_id, no matter what you call the model. The exception to this is if you override the column names by using join_self_as and join_other_as, which have to be specified on both models in a relationship. This is how I joined two models that were stored on the same table, and shared most of the same relationships, but had subtle differences. It becomes hard to maintain, however, and it's even harder to explain properly.
[/quote]
Yes of course sorry. This does allow you to customise foreign keys. I just need to get my head around it and then I think I might be able to solve the problem.

If you want better assistance, I suggest you put together some clear examples, showing example code & database structure, the expected result, and the result or errors you actually got. I would prefer if you could ZIP up the example content, and send it to me in a PM. I'd be happy to look at it then. :-)

Thanks I'll do this at some point, if needs be, after I've cracked advanced relationships.