Only show records associated with group

Hi all, I appreciate the help in advance.

I'm trying to create a personnel management application, where as
records (employee information) would be associated with a group.
Administrators should be allowed to access and edit (or view only
based on group), employees multiple groups... for the sharing of
information between departments.

My first thought was to assign each employee's record to a group.
Then in an "access" table, add entries for each administrator / group
combination for access. So that when an administrator goes the
personnel page, it would query the access table and retrieve the
groups he/she has access to... then displays everyone in those groups.

It seems I'm making it more complicated than it needs to be. Does
anyone have a better suggestion, or an easier way to implement this?

Thanks for reading...
Logan

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 cake-php@googlegroups.com
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?hl=en