One-way relationship

I have Items and Units, and want each Item to have one Unit, but that
unit can be used by many.

Items Table
id - int
name - varchar
description varchar
unit_id - int

Units Table
id - int
name - varchar
description - varchar

Items Model
var $hasOne = array( 'Units' => array( 'className' => 'Unit' ) );

Units Model
Nothing, but previously I tried: var $belongsTo = array( 'Items' =>
array( 'className' => 'Item' ) );

When I'm in the scaffolding (List Items) I get:
Warning (512): SQL Error: 1054: Unknown column 'Units.item_id' in 'on
clause' [CORE/cake/libs/model/datasources/dbo_source.php, line 684]

And in the Edit Item screen, the Units drop-down is empty. Any idea
what I'm doing wrong? Essentially the Units table are just to populate
a drop-down in the Item entry form, but I'd like it to auto-populate
in scaffold.

--
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