HABTM relationship between 3 tables

I've done a lot of searching and reading, but I can't seem to figure out the best way to handle this.  Any advice would be appreciated:

I have a Customer model and a Departure model that have a HABTM relationship.  (Customers can sign up for multiple Departures.)  I need to keep track of the status for each of these associations (i.e. a Customer can be 'booked' for Departure #1, but may only be 'penciled-in' for Departure #2).  I created a table, customer_departure_statuses, that holds all of the possible statuses for a customer_departure object.

I have created a Customers_departures table that holds the following fields:

id

customer_id

departure_id

customer_departure_status_id

(Note: there are other fields in the customers_departures table, but they are nullable and don't seem to have an impact on my problem.)

Right now, I have $hasAndBelongsToMany defined in each of the three models: Customer, Departure, CustomerDepartureStatus.  Here is how the association is defined in the Departure model:

public $hasAndBelongsToMany = array(

'Customer' => array(

'className' => 'Customer',

'joinTable' => 'customers_departures',

'foreignKey' => 'departure_id',

'associationForeignKey' => 'customer_id',

'unique' => false,

'conditions' => '',

'fields' => '',

'order' => '',

'limit' => '',

'offset' => '',

'finderQuery' => '',

'deleteQuery' => '',

'insertQuery' => ''

),

'CustomerDepartureStatus' => array(

'className' => 'CustomerDepartureStatus',

'joinTable' => 'customers_departures',

'foreignKey' => 'departure_id',

'associateForeignKey' => 'customer_departure_status_id',

'unique' => false,

'conditions' => '',

'fields' => '',

'order' => '',

'limit' => '',

'offset' => '',

'finderQuery' => '',

)

I have the following $data set in an array:

Array  (      [Customer] => Array          (              [id] => 2              [person_id] => 15              [passportinformation] => passport info              [birthdate] => 1999-01-01 10:14:00              [placeofbirth] => The North Pole              [height] => 5'6"              [inseam] => 28              [bikenotes] => This is a bike note              [medical_need_id] => 1              [dietary_need_id] => 1              [referral_type_id] => 1              [passport_name] =>               [issue_date] =>               [expire_date] =>               [gender_id] => 1          )        [Departure] => Array          (              [id] => 1              [startdate] => 2014-05-01              [enddate] => 2014-05-08              [product_id] => 1              [departure_status_id] => 1              [CustomersDeparture] => Array                  (                      [id] => 1                      [customer_id] => 5                      [departure_id] => 1                      [room_request_id] =>                       [room_assignment_id] =>                       [bike_id] =>                       [customer_departure_status_id] => 1                  )            )        [CustomerDepartureStatus] => Array          (              [id] => 1              [name] => Pencil In              [CustomersDeparture] => Array                  (                      [id] => 1                      [customer_id] => 5                      [departure_id] => 1                      [room_request_id] =>                       [room_assignment_id] =>                       [bike_id] =>                       [customer_departure_status_id] => 1                  )            )    )

When I try to run this line of code - $this->Person->Customer->saveAll($data) - I get the following error:  

Error:   	SQLSTATE[HY000]: General error: 1364 Field 'customer_departure_status_id' doesn't have a default value

(Note: This is called from the Person controller, which Customer $belongsTo.  I don't think this is influencing the save call, but I've included the information just in case it is relevant.)

I've started reading up on the hasMany through option, but I'm not sure if that is exactly what I need or not.  Am I doing this right?  If so, what do I need to do to track down the error that I'm getting?

--
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+unsubscribe@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.
For more options, visit https://groups.google.com/d/optout.