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.
- 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
- 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.
- 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.