# Action with "many to ..." relationships

**URL:** <https://community.glideapps.com/t/action-with-many-to-relationships/43373>\
**Category:** Ask for Help\
**Created:** [June 22, 2022, 3:12pm UTC](https://community.glideapps.com/t/action-with-many-to-relationships/43373 "2022-06-22T15:12:42Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Berengere](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/berengere/32/38587_2.png) [@Berengere](https://community.glideapps.com/u/Berengere)\
**Post date:** [June 22, 2022, 3:12pm UTC](https://community.glideapps.com/t/action-with-many-to-relationships/43373/1 "2022-06-22T15:12:42Z")

</div>

Hello,  
I am facing a persistent problem… 🤯  
I work directly on glide editor:  
**I have an Events table, a User table, an Event\_participant table.**  
**I would like a user to be able to subscribe or unsubscribe from an event.**

My user is on the event page. When registering, with the “Add row” action, it’s create a new row in my “Event\_participant” sheet.  
However I have a real **problem to delete the line**. In fact, the “delete row” action does not allow you to delete a row in other sheet of your page (here Events).  
I tried to create relationships, but I notice that actions are possible with “one to …” relationships but not with “many to…” relationships.  
In desperation, I thought to myself that I would create a column for each potential participant. It’s not very pretty, but in my case I could limit registrations to 20 people.  
However, this solution gives me another problem:  
I would like to retrieve the participant’s ID in the Event table in one of the columns Part\_1, Part\_2,…Part\_20 depending on the first which will be empty.  
Do you have an idea ?  
Thanks !

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [June 22, 2022, 3:59pm UTC](https://community.glideapps.com/t/action-with-many-to-relationships/43373/2 "2022-06-22T15:59:55Z")

</div>

You can use the relation from event to the user registration. I talk a bit about it here:  
[https://community.glideapps.com/t/experts-top-tips/39730/2?u=robert\_petitto](https://community.glideapps.com/t/experts-top-tips/39730/2)

And here:

[![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/1/710efd757d00cc0b9b980d772ac5503199299dd8.jpeg "Glide: TWO WAYS to Allow Users to RSVP, Register and Join") ](https://www.youtube.com/watch?v=IWZWB1hn3DU)

---

<div class="post-metadata">

**Author:** ![Berengere](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/berengere/32/38587_2.png) [@Berengere](https://community.glideapps.com/u/Berengere)\
**Post date:** [June 23, 2022, 12:51pm UTC](https://community.glideapps.com/t/action-with-many-to-relationships/43373/3 "2022-06-23T12:51:51Z")

</div>

A very big thank you… 🙏  
I was gravitating around the solution but I clearly couldn’t have found it on my own.  
The first link doesn’t work but the second video talk exactly about my problem. I followed the steps and it works.  
This is not the first time I see one of your tutorials and you know “some heroes don’t wear a cape”.  
Thank you so much

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [June 23, 2022, 3:12pm UTC](https://community.glideapps.com/t/action-with-many-to-relationships/43373/4 "2022-06-23T15:12:30Z")

</div>

Thanks for the kind words. Here’s the first link again:

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [June 24, 2022, 3:12pm UTC](https://community.glideapps.com/t/action-with-many-to-relationships/43373/5 "2022-06-24T15:12:59Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
