Thanks Fuzz10,
I've had a look at how to remove fields and add them again, but I am struggling to get it working. I wonder if you have an example I could see?
Assuming I have the code below, and I would like to achieve having dropdowns which show "$title - $composer" (as currently i have pieces called the same thing by different people!); Would i have to put the getCMSFields() call in Service.php and remove each of the fields relating to Repertoire so they can be re-added as dropdowns - or have one entry in Repertoire.php? Also, I don't really understand what I am supposed to add the field to as it appears that I have to attach it to a tab? Sorry - I am probably getting it all wrong!
Repertoire.php
class Repertoire {
static $db = new array (
'title' = > 'varchar',
'composer' => 'varchar'
);
}
Service.php
class Service {
static $db = new array (
'type' = > 'enum('Matins, Evensong', 'Evensong')',
'location' => 'varchar'
);
static $has_one = new array(
'Introit' => 'Repertoire',
'Anthem' => 'Repertoire',
'Setting' => 'Repertoire'
);
}