Thank you Mr Ullman for your quick response. This should be simple and I apologize for my ignorance in this situation but I am simply not seeing my relation.
MediaArchive is my main form. BibleDetails is a lookup table that is populating the dropdown list for the Bible field on the MediaArchive form.
So in my MediaArchive form I established the following relation
public function relations()
{
return array(
'Bible' => array(self::HAS_ONE, 'BibleDetails','BibleEnglish')
);
}
In BibleDetails I added this to my relations
public function relations()
{
return array(
'BibleEnglish' => array(self::BELONGS_TO, 'MediaArchive','Bible')
);
}
and then in my _view.php for my MediaArchive form I inserted
<?php echo CHtml::encode($model->Bible->BibleEnglish); ?>
OK, after all the chuckles could you please advise. I am not understanding relations. Thank you!