Many to Many Relationship via Form Administration

Dear all, I'm currently struggling with a good approach to administrate Many to Many Relationships via Form/ Tables on the user front end.

Example:

• Users Table
• Groups Table
• Connector Table Group_User

Basically every User can belong to many groups which should be attached via input form. Now I’m searching for a n easy approach to administrate those dependencies via input form/ table/ pages without using multiselect. The reason is that there might be 1000 Groups.

My current approach/ idea:

Step 1 - Display Users Table The Front end user can see a Users Table and will select 1 User.

Step 2 - User Edit Page The User Form Edit page shows up. This page has two tabs.

Properties Tab: Here you can edit all user information with a standard input form. Groups Tab: An additional table shows the groups to which the user has been assigned to.

Step 3 - Administration of the Assigned Groups Table When I want the user to be in additional groups, I would click on “Add Groups” and a third table would appear. This table shows all Groups to which the user has not been assigned to. Via Checkboxes I could select the Rows (Groups) that I want to add to the Users Group table.

Does anyone has a similar problem / user case and can share how you handled it.

Thanks, Graveeel