I do think that you need to take a look at The Join Model in the CakePHP book at: http://book.cakephp.org/#!/view/1650/hasMany-through-The-Join-Model
as what you want is to have additional data in your intersection table and CakePHP normal usage does not allow that. Whether or not it will be able to automatically populate the created and modified columns is not something I am sure about though! Enjoy, John On Feb 17, 5:19 pm, rgreenphotodesign <[email protected]> wrote: > Just for good measure here are my relationships in the models: > > Activity: > > var $hasAndBelongsToMany = array( > 'Statustype' => array( > 'className' => 'Statustype', > 'joinTable' => 'activity_statuses', > 'foreignKey' => 'activities_id', > 'associationForeignKey' => 'statustypes_id', > 'unique' => false, > 'conditions' => '', > 'fields' => '', > 'order' => '', > 'limit' => '', > 'offset' => '', > 'finderQuery' => '', > 'deleteQuery' => '', > 'insertQuery' => '' > ), > ); > > ActivityStatus: > > var $belongsTo = array( > 'Statustype' => array( > 'className' => 'Statustype', > 'foreignKey' => 'statustypes_id', > 'conditions' => '', > 'fields' => '', > 'order' => '' > ), > 'Activity' => array( > 'className' => 'Activity', > 'foreignKey' => 'activities_id', > 'conditions' => '', > 'fields' => '', > 'order' => '' > ), > ); > > I don't define any relationships in the Statustype model. > [snip] -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
