Hello, Just came across a case where hasMany/belongsTo relations requires more than one foreign keys from the same model.
Take a wish list for instance. There's two models, User and Wish. A user can have multiple wishes for him self for sure. And he/she can pick up others' wishes and claim a exclusive right to help fullful them. Vice versa on Wish model's part. In 'wishes' table in DB, there's two foreign keys: 'user_id' indicating the owner of a wish, and 'claim_by' indicating the kind- hearted claimer. Looked into some documents and make the following code, which doesn't work. Looking for help here :) BTW, do you think HABTM is a better solution in such a case like this? <?php class user extends AppModel{ var $name = 'User'; var $hasMany = array( 'Wish' => array( 'className' => 'Wish', 'foreignKey' => 'user_id'), 'ClaimedItem' => array( 'className' => 'Wish', 'foreignKey' => 'claim_by' ), ); } ?> <?php class wish extends AppModel{ var $name = 'Wish'; var $belongsTo = array( 'User' => array( 'className' => 'User', 'foreignKey' => 'user_id'), 'Claimer' => array( 'className' => 'User', 'foreignKey' => 'claim_by' ) ); } ?> --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---