Note the upgraded forum! If you are experiencing issues logging in, you may need to reset your password which should send an email. If the email doesn't arrive, be sure to check your spam folder just in case.
Many to many combo box issue on edit
I have created a many to many relationship using a custom lookup table (ie not Fuel's relationships table). Within the CMS record for the candidate table, the multi select appears OK, with the left hand textarea populated with the correct records in the related table. Selecting a record into the right hand textarea, and saving, creates the correct foreign and candidate keys in the lookup table. But... on editing the record, the right hand box does not show the saved relationships.
I should declare that the models for all 3 tables (candidate, lookup, foreign) are using the 'dsn' property to point to a remote database, if that should make any difference.
So the has_many property looks like:
public $has_many = array(
'authorities' => array(
// this model has many 'authorities'
'model' => array('app' => 'authorities_model'),
// the lookup table
'relationships_model' => 'authority_installation_model',
// the foreign key of the 'has many' table in lookup table
'foreign_key' => 'authority_id',
// this table's primary key in the lookup table
'candidate_key' => 'installation_id'
What might be preventing the records showing in the right hand combo when saved?