How would one set up this model association?

Hi I have three tables all linked to one lookup table like so:

+-----------------------------------------------------------------------------
+
| AUXProductOption |
+----
+-----------------------------------------------------------------------
+
| id | productOptionName |
+----
+-----------------------------------------------------------------------
+
| 1 | Death, Total and Permanent Disability, Tempor |
| 5 | total,
540 |
| 6 | test fixed amount
|
+----
+-----------------------------------------------------------------------
+

+-----------------------------------------------------------------------------
+
| AUXProductOptionFields |
+----
+-----------------------------------------------------------------------
+
| id |
name |
+----
+-----------------------------------------------------------------------
+
| 1 | Test
Field |
+----
+-----------------------------------------------------------------------
+

+-----------------------------------------------------------------------------
+
| AUXProductOptionFieldValue |
+----
+-----------------------------------------------------------------------
+
| id |
value |
+----
+-----------------------------------------------------------------------
+
| 1 |
1001 |
| 2 | This is rover calling back huston |
+----
+-----------------------------------------------------------------------
+

+-------------------------------------------------------------------------------------------------------------------------------
+
|
AUXProductOption_has_AUXProductOptionFields
|
+-------------------------------------------------------------------------------------------------------------------------------
+
| AUXProductOption_id | AUXProductOptionFields_id |
AUXProductOptionFieldValue_id |
+--------------------------------
+-----------------------------------------
+---------------------------------------------------+
| 1 |
1 | 1
|
| 1 |
1 | 2
|
| 5 |
1 | 2
|
| 6 |
1 | 1
|
+-------------------------------
+------------------------------------------
+---------------------------------------------------+

my models look like so :
[CODE]
class AUXProductOption extends AppModel {
var $name = 'AUXProductOption';
var $useTable = 'AUXProductOption';
var $displayField = 'productOptionName';
//The Associations below have been created with all possible keys,
those that are not needed can be removed

var $hasAndBelongsToMany = array(
'AUXProductOptionField' => array(
'className' => 'AUXProductOptionField',
'joinTable' => 'AUXProductOption_has_AUXProductOptionFields',
'foreignKey' => 'AUXProductOptionFields_id',
'associationForeignKey' => 'AUXProductOption_id',
'unique' => true,
'conditions' => '',
'fields' => '',
'order' => '',
'limit' => '',
'offset' => '',
'finderQuery' => '',
'deleteQuery' => '',
'insertQuery' => ''
),
'AUXProductOptionFieldValue' => array(
'className' => 'AUXProductOptionFieldValue',
'joinTable' => 'AUXProductOption_has_AUXProductOptionFields',
'foreignKey' => 'AUXProductOptionFieldValue_id',
'associationForeignKey' => 'AUXProductOption_id',
'unique' => true,
'conditions' => '',
'fields' => '',
'order' => '',
'limit' => '',
'offset' => '',
'finderQuery' => '',
'deleteQuery' => '',
'insertQuery' => ''
)
);

}

class AUXProductOptionField extends AppModel {
var $name = 'AUXProductOptionField';
var $useTable = 'AUXProductOptionFields';
var $displayField = 'name';

var $hasAndBelongsToMany = array(
'AUXProductOptionFieldValue' => array(
'className' => 'AUXProductOptionFieldValue',
'joinTable' => 'AUXProductOption_has_AUXProductOptionFields',
'foreignKey' => 'AUXProductOptionFieldValue_id',
'associationForeignKey' => 'AUXProductOptionFields_id',
'unique' => true,
'conditions' => '',
'fields' => '',
'order' => '',
'limit' => '',
'offset' => '',
'finderQuery' => '',
'deleteQuery' => '',
'insertQuery' => ''
),
'AUXProductOption' => array(
'className' => 'AUXProductOption',
'joinTable' => 'AUXProductOption_has_AUXProductOptionFields',
'foreignKey' => 'AUXProductOption_id',
'associationForeignKey' => 'AUXProductOptionFields_id',
'unique' => true,
'conditions' => '',
'fields' => '',
'order' => '',
'limit' => '',
'offset' => '',
'finderQuery' => '',
'deleteQuery' => '',
'insertQuery' => ''
)
);
}

class AUXProductOptionFieldValue extends AppModel {
var $name = 'AUXProductOptionFieldValue';
var $useTable = 'AUXProductOptionFieldValue';
var $displayField = 'value';
//The Associations below have been created with all possible keys,
those that are not needed can be removed

var $hasAndBelongsToMany = array(
'AUXProductOptionField' => array(
'className' => 'AUXProductOptionField',
'joinTable' => 'AUXProductOption_has_AUXProductOptionFields',
'foreignKey' => 'AUXProductOptionFields_id',
'associationForeignKey' => 'AUXProductOptionFieldValue_id',
'unique' => true,
'conditions' => '',
'fields' => '',
'order' => '',
'limit' => '',
'offset' => '',
'finderQuery' => '',
'deleteQuery' => '',
'insertQuery' => ''
),
'AUXProductOption' => array(
'className' => 'AUXProductOption',
'joinTable' => 'AUXProductOption_has_AUXProductOptionFields',
'foreignKey' => 'AUXProductOption_id',
'associationForeignKey' => 'AUXProductOptionFieldValue_id',
'unique' => true,
'conditions' => '',
'fields' => '',
'order' => '',
'limit' => '',
'offset' => '',
'finderQuery' => '',
'deleteQuery' => '',
'insertQuery' => ''
)
);

}

[/CODE]

My problem currently is that I cannot do inserts and the data is read
out only for the first product option with the first field value.

Thanks in advance.

--
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
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php