# Many to Many Relationship Issue

**URL:** <https://forum.adalo.com/t/many-to-many-relationship-issue/30138>\
**Category:** Database\
**Created:** [July 29, 2022, 4:55pm UTC](https://forum.adalo.com/t/many-to-many-relationship-issue/30138 "2022-07-29T16:55:23Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![knuggie](https://avatars.discourse-cdn.com/v4/letter/k/76d3ee/32.png) [@knuggie](https://forum.adalo.com/u/knuggie)\
**Post date:** [July 29, 2022, 4:55pm UTC](https://forum.adalo.com/t/many-to-many-relationship-issue/30138/1 "2022-07-29T16:55:23Z")

</div>

Hi there!

I have two collections that have a many to many relationship with one another - a **User** can have multiple **Assignments** and an **Assignment** can have multiple **Users**.

I’ve been struggling to find a way to implement the following:

I want a form where I can create a new assignment that is assigned to a specific subset of users (specifically only the users with two criteria). I already have a screen to create the body of the assignment (where I can add questions) but I am struggling to figure out how I can give this assignment to multiple Users.

Ideally I would have a screen with all users on it, and I could simply checkbox select the ones I would like to add to the assignment.

Or

I could instead ideally just have an action on a button that automatically assigns the assignment to all users with certain criteria (however right now I only know how to give an assignment to one User at a time with an action)

Does anyone know how I could go about doing this?

Thanks!

---

<div class="post-metadata">

**Author:** ![Rozza](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/rozza/32/22780_2.png) [@Rozza](https://forum.adalo.com/u/Rozza)\
**Post date:** [July 30, 2022, 2:28am UTC](https://forum.adalo.com/t/many-to-many-relationship-issue/30138/2 "2022-07-30T02:28:20Z")

</div>

Hi  
You can use a toggle in a custom list to add users from your list to the current assignment. Or vice Versa.

You can use a countdown timer to essentially do the same automatically, but this has limits of say 20 records to work reliably. It is very heavy on the device processes.

Just filter the list according to your criteria.

I would create the assignment on a button click, then load a screen with a form to update the new / current assignment. Second update screen or pop up contains your list of users with toggle or countdown timer👍

---

<div class="post-metadata">

**Author:** ![knuggie](https://avatars.discourse-cdn.com/v4/letter/k/76d3ee/32.png) [@knuggie](https://forum.adalo.com/u/knuggie)\
**Post date:** [August 4, 2022, 4:07pm UTC](https://forum.adalo.com/t/many-to-many-relationship-issue/30138/3 "2022-08-04T16:07:57Z")

</div>

Hi @Rozza - The custom list with toggles worked great!

Thanks so much!