Actually, the more I think about this I realize this cannot be done with some magic in the view. I'll have to do it in the controller or the model. Never mind.
However, any suggestions of the best way to do this in the model or controller would be appreciated. I can think of a SQL query using a JOIN but I'm not sure how to force CakePHP to use a join in a model association. BTW I'm using CakePHP 1.3 Ken -- 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 [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
