Thanks for the response, Cricket. Unfortunately, I can't use the HABTM relationship, as the joining table contains notes notes relating to the link.
I think the idea of storing the number in the member table could be the best option. Think I'll add a beforeSave method to the Role model to ensure it's kept up to date with each save. It's that or filter the find results each time. Overhead isn't too much of an issue on this project, so no need ot test the 'cheapest' option on this. Thanks, T Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
