[dbforms] Checkboxes

[Neal Katz]

Does anyone have an easy way to implement the following:   I have 3 tables users (user_name,user_pass)  ,  roles ( role_name )  and user_roles ( user_name , role_name ).   I want to have an input screen where I prompt for a user_name, and then show a set of checkboxes for each entry in the role table.   After the user commits, the system will create a new record in the users table and additional records in the user_roles table, one for each role selected.     I’m asking because all I can think of is bunch of brute force ways to do this, involving writing a custom controller. I like to avoid that if possible.   Thanks in advance   Neal   p.s. if this looks familiar it’s the standard tomcat schema for setting up a realm for authentication.