Okay this will be a SQL question for whoever out there might have an idea on a solution, I'd much appreciate it.

• I have 4 custom Roles in addition to the core roles.
• I want the user to only be in 1 of the 4 roles at a time

so the following is the desired situation.

1. Read only Checkbox group displays which role/s (of the 4) the user is in. But not any of the core roles taken from the database
2. Radio Group below - When the user click one of the 4 roles and updates, that role is added and any of the other 3 are removed.
3. I guess I need a contingency for the situation where an admin accidental adds the user to 2 of the roles via the role panel. Thus the check boxes then the radio.