I would drop MODULES table which seems meaningless to me and rename MODULES_ROLES_USERS to MODULES instead. Then in MODULES model, define Modules hasMany ROLES and USERS. When adding new module, use generatelist() to make lists for Roles and Users.
On Jul 23, 11:20 am, rtanz <[EMAIL PROTECTED]> wrote: > i have a modules table storing module info: > MODULES > id > name > .... > > and a roles table storing a number of roles: > ROLES > id > name > > and a users table storing info about users: > USERS > id > name > .... > > and a join table storing the links between them, > MODULES_ROLES_USERS > id > module_id > role_id > user_id > > Now I would like that when I create a new MODULE I will be given the > option to select a USER(dropdown) and his ROLE(dropdown) within that > module. How can i do this and was i correct in making that join table > or should is this functionality done another way in cakephp? thanks --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---
