Ok I found my answer before this question cleared moderation. public $hasAndBelongsToMany = array( 'Role' => array( 'className' => 'Role', 'joinTable' => 'roles_users', 'foreignKey' => 'user_id', 'assosciationForeignKey' => 'role_id', 'unique' => 'keepExisting' ) );
function __construct($id = false, $table = null, $ds = null) { $this->hasAndBelongsToMany['Role']['conditions'] = array('RolesUser.site_id' => Configure::read('Settings.site_id')); parent::__construct($id, $table, $ds); } And as it turns out is was in this group going back to 2010 sometime. -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscr...@googlegroups.com. To post to this group, send email to cake-php@googlegroups.com. Visit this group at http://groups.google.com/group/cake-php?hl=en. For more options, visit https://groups.google.com/groups/opt_out.