# Help linking client data across tabs in my first Glide app for a spa

**URL:** <https://community.glideapps.com/t/help-linking-client-data-across-tabs-in-my-first-glide-app-for-a-spa/82042>\
**Category:** Ask for Help\
**Created:** [May 25, 2025, 7:40pm UTC](https://community.glideapps.com/t/help-linking-client-data-across-tabs-in-my-first-glide-app-for-a-spa/82042 "2025-05-25T19:40:18Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jerryto26](https://avatars.discourse-cdn.com/v4/letter/j/b5a626/32.png) [@Jerryto26](https://community.glideapps.com/u/Jerryto26)\
**Post date:** [May 25, 2025, 7:40pm UTC](https://community.glideapps.com/t/help-linking-client-data-across-tabs-in-my-first-glide-app-for-a-spa/82042/1 "2025-05-25T19:40:18Z")

</div>

Hi everyone! I’m a complete beginner at building apps — this is my very first time and I really don’t want to give up halfway through. 😅

I’m trying to build an app for my wife’s spa, where she can store the clinical history of her patients. So far, I’ve created three tabs/screens: **Clients** , **Clinic Record** , and **Sessions**.

What I want to do is: every time I add a new record in the **Clients** tab, I’d like the client’s name to automatically appear as a choice in the **Clinic Record** tab, so I can continue entering their clinical information.

Also, in the **Sessions** tab — which will be used to record each of the patient’s visits — I’d like to link each session to a specific client as well.

Does anyone know how I can set this up?

Thanks in advance!

---

<div class="post-metadata">

**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\
**Post date:** [May 25, 2025, 8:11pm UTC](https://community.glideapps.com/t/help-linking-client-data-across-tabs-in-my-first-glide-app-for-a-spa/82042/2 "2025-05-25T20:11:40Z")

</div>

> [@Jerryto26](#):
>
> I’d like the client’s name to automatically appear as a choice in the **Clinic Record** tab, so I can continue entering their clinical information.

You can use the clients table as the source of a choice component, or create a query column to get data from the clients table and use the column as the source.

> [@Jerryto26](#):
>
> Also, in the **Sessions** tab — which will be used to record each of the patient’s visits — I’d like to link each session to a specific client as well.

You will need to use the row id of each client (add a new column in clients table of type row id, if you don’t already have one) and put it in a client id column for each sessions. Then, you will be able to create a relation column with the clients table =\> row id and the client id column of this row.

---

<div class="post-metadata">

**Author:** ![Jerryto26](https://avatars.discourse-cdn.com/v4/letter/j/b5a626/32.png) [@Jerryto26](https://community.glideapps.com/u/Jerryto26)\
**Post date:** [May 29, 2025, 5:22am UTC](https://community.glideapps.com/t/help-linking-client-data-across-tabs-in-my-first-glide-app-for-a-spa/82042/3 "2025-05-29T05:22:19Z")

</div>

Thank you very much, Maxime. I created a ‘Name’ column and used it as the relation column between the different tabs, using a Choice component as you suggested. However, I’m curious about the part regarding the query column — what are the benefits of using that option?

---

<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:** [May 29, 2025, 5:39am UTC](https://community.glideapps.com/t/help-linking-client-data-across-tabs-in-my-first-glide-app-for-a-spa/82042/4 "2025-05-29T05:39:39Z")

</div>

> [@Jerryto26](#):
>
> However, I’m curious about the part regarding the query column — what are the benefits of using that option?

The query column allows you to apply filters, sorting and limits. It is arguably one of the most powerful computed column types.

> **[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:** ![Jerryto26](https://avatars.discourse-cdn.com/v4/letter/j/b5a626/32.png) [@Jerryto26](https://community.glideapps.com/u/Jerryto26)\
**Post date:** [May 30, 2025, 3:44am UTC](https://community.glideapps.com/t/help-linking-client-data-across-tabs-in-my-first-glide-app-for-a-spa/82042/5 "2025-05-30T03:44:33Z")

</div>

Thanks Darren
