# How can I use correctly de Relation function?

**URL:** <https://community.glideapps.com/t/how-can-i-use-correctly-de-relation-function/83120>\
**Category:** Ask for Help\
**Created:** [July 11, 2025, 11:41pm UTC](https://community.glideapps.com/t/how-can-i-use-correctly-de-relation-function/83120 "2025-07-11T23:41:52Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![EmilioPartida](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/emiliopartida/32/87901_2.png) [@EmilioPartida](https://community.glideapps.com/u/EmilioPartida)\
**Post date:** [July 11, 2025, 11:41pm UTC](https://community.glideapps.com/t/how-can-i-use-correctly-de-relation-function/83120/1 "2025-07-11T23:41:52Z")

</div>

I need to relate the data from the “Cantidad” column in the “Fechas” table to a new column in the “Resumen” table, but they need to be related through the “Mes” and “Año” columns. I’ve tried several ways, but none of them work. How can I do it correctly?

 ![imagen_2025-07-11_173716279](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/b/fb759b3a15d67491db3692128446383dceb1a517.png)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/8/884b963895ca11720534446409660803beb51e12.png)

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [July 11, 2025, 11:52pm UTC](https://community.glideapps.com/t/how-can-i-use-correctly-de-relation-function/83120/2 "2025-07-11T23:52:53Z")

</div>

Try using a Query column.

---

<div class="post-metadata">

**Author:** ![EmilioPartida](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/emiliopartida/32/87901_2.png) [@EmilioPartida](https://community.glideapps.com/u/EmilioPartida)\
**Post date:** [July 12, 2025, 12:34am UTC](https://community.glideapps.com/t/how-can-i-use-correctly-de-relation-function/83120/3 "2025-07-12T00:34:53Z")

</div>

I’ve already tried using Query, but it only selects the “Fechas” table; it doesn’t let me select the column I want.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/d/fd67af0c80f44b32a1fad2cf1108ce6a0bdadb12.jpeg)

---

<div class="post-metadata">

**Author:** ![Mazen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mazen/32/84042_2.png) [@Mazen](https://community.glideapps.com/u/Mazen)\
**Post date:** [July 12, 2025, 12:45am UTC](https://community.glideapps.com/t/how-can-i-use-correctly-de-relation-function/83120/4 "2025-07-12T00:45:21Z")

</div>

Use Lookup or Single Value

---

<div class="post-metadata">

**Author:** ![EmilioPartida](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/emiliopartida/32/87901_2.png) [@EmilioPartida](https://community.glideapps.com/u/EmilioPartida)\
**Post date:** [July 12, 2025, 12:54am UTC](https://community.glideapps.com/t/how-can-i-use-correctly-de-relation-function/83120/5 "2025-07-12T00:54:14Z")

</div>

I’ve also tried using Lookup and Single Value.

Lookup it might work, but I don’t know what to do next. Can I apply a filter to this column or something like that?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/6/669d9fbe67e9a30567ca3bba26fd0facf7dea09d.jpeg)

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [July 12, 2025, 1:54am UTC](https://community.glideapps.com/t/how-can-i-use-correctly-de-relation-function/83120/6 "2025-07-12T01:54:29Z")

</div>

> [@EmilioPartida](#):
>
> it only selects the “Fechas” table;

You have to set the filter in a query column. You start by selecting the table and then you need to set the filter to get the matching rows you want.

> **[Query Column | Glide Docs](https://www.glideapps.com/docs/automation/computed-columns/query-column)**
>
> Create complex relations in your data with conditional filtering, sorting, and limits.

---

<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:** [July 12, 2025, 3:02am UTC](https://community.glideapps.com/t/how-can-i-use-correctly-de-relation-function/83120/7 "2025-07-12T03:02:17Z")

</div>

Video is a year or so old — but it might help:

[![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/6/367cde796c7b03bb7ee9befb4600de0872b27e54.jpeg "Glide 101: Query Column Replaces DOZENS of Computed Columns") ](https://www.youtube.com/watch?v=2K3KzgbrXT8)

---

<div class="post-metadata">

**Author:** ![EmilioPartida](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/emiliopartida/32/87901_2.png) [@EmilioPartida](https://community.glideapps.com/u/EmilioPartida)\
**Post date:** [July 12, 2025, 4:31am UTC](https://community.glideapps.com/t/how-can-i-use-correctly-de-relation-function/83120/8 "2025-07-12T04:31:22Z")

</div>

Thanks a lot! @Jeff_Hager @Robert_Petitto, it worked well with those videos! 🙂

---

<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:** [July 19, 2025, 4:31am UTC](https://community.glideapps.com/t/how-can-i-use-correctly-de-relation-function/83120/9 "2025-07-19T04:31:44Z")

</div>

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