# Deleting a row from another table

**URL:** https://community.glideapps.com/t/deleting-a-row-from-another-table/58915
**Category:** Ask for Help
**Created:** [March 8, 2023, 2:43pm UTC](https://community.glideapps.com/t/deleting-a-row-from-another-table/58915 "2023-03-08T14:43:58Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Ludotomatic](https://avatars.discourse-cdn.com/v4/letter/l/6f9a4e/32.png) [@Ludotomatic](https://community.glideapps.com/u/Ludotomatic)
#### Post date: [March 8, 2023, 2:43pm UTC](https://community.glideapps.com/t/deleting-a-row-from-another-table/58915/1 "2023-03-08T14:43:58Z")

</div>

Hi, so I’m sure this has been addressed before but I can’t find a related topic.

I have an Events database, a Users database, and a Going database which basically consists of a user and an event where the user is going.

Same thing with Interested table.

I managed to set “going” and “interested” buttons on the Event page that create rows in both Going and Interested tables (User is connected user, event is this event), but I can’t figure out how to delete the created row, if the user is no longer interested or no longer going. All I manage to do is deleting all “Interested” or all “Going” rows matching this event, so I also delete the fact that other users are either interested or going. There must be a way with relations but i’m struggling.

Thanks for your help!

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 8, 2023, 2:46pm UTC](https://community.glideapps.com/t/deleting-a-row-from-another-table/58915/2 "2023-03-08T14:46:32Z")

</div>

You need to establish a _single_ relation that matches just the row you want to delete, and then use a Delete Row Action via that relation.

To do that, you probably want a template column in each table that combines the UserID and EventID, and then use those two columns to create the relation.

---

<div class="post-metadata">

### Author: ![Ludotomatic](https://avatars.discourse-cdn.com/v4/letter/l/6f9a4e/32.png) [@Ludotomatic](https://community.glideapps.com/u/Ludotomatic)
#### Post date: [March 8, 2023, 5:29pm UTC](https://community.glideapps.com/t/deleting-a-row-from-another-table/58915/3 "2023-03-08T17:29:40Z")

</div>

Awesome, thank you!  
I created templates and this works flawlessly

---

<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: [March 9, 2023, 5:30pm UTC](https://community.glideapps.com/t/deleting-a-row-from-another-table/58915/4 "2023-03-09T17:30:31Z")

</div>

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