To answer your second question, yes, you prefix using the association name. So, if you have a User model and then later a Creator association that references the user model, you would use Creator as the model name. It would also appear like that in the results. This allows you to have a single model searched multiple times in the same query, as well.
A lot of people have completed very complex find calls in CakePHP successfully, you just may need to ask. Also, if worse comes to worse, you can always create a direct query (though usually unnecessary). CakePHP does it's best to help you but not get so in the way as to hinder you. -- 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
