# Creating Relation Columns

**URL:** <https://community.glideapps.com/t/creating-relation-columns/25345>\
**Category:** Ask for Help\
**Created:** [April 9, 2021, 12:55pm UTC](https://community.glideapps.com/t/creating-relation-columns/25345 "2021-04-09T12:55:40Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![NOBA\_Ventures](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/noba_ventures/32/14991_2.png) [@NOBA\_Ventures](https://community.glideapps.com/u/NOBA_Ventures)\
**Post date:** [April 9, 2021, 12:55pm UTC](https://community.glideapps.com/t/creating-relation-columns/25345/1 "2021-04-09T12:55:40Z")

</div>

Hello!

I’m trying to create an app that is basically a catalog of services provides by one person to several clients. The owner has different services categories and each category has its own deliverables. I’m trying to put together an admin panel where the owner can access his different clients and select the services a specific client has bought and also upload the related deliverables.

What I’ve done so far is:

- **on the users sheet** I’m using the email as the key to create a relation among sheets.
- **a services sheet** with a column for “service code”
- **deliverables sheet** with a column for the related “service code” and also another one with “deliverable code”
- **service log sheet** that stores the email of the user and also the services and services codes for each service bought by each user. Each service bought is activated by its own column with a boolean element and then another column translates that into the service code

Now what I’m missing is how to create a relation between **service log sheet** (and all the services bought by a client) and the **service sheet** so later I can create a **deliverables log sheet**. Any ideas?

Does this makes sense? Thanks!

---

<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:** [April 11, 2021, 6:20pm UTC](https://community.glideapps.com/t/creating-relation-columns/25345/2 "2021-04-11T18:20:27Z")

</div>

Do you have any screenshots of your data? I’m guess you would need some sort of array list of selected services in the log sheet, then create a relation from that to the services sheet. Depending on how your data is structured, it should be easy to create that relation.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [April 13, 2021, 11:31pm UTC](https://community.glideapps.com/t/creating-relation-columns/25345/4 "2021-04-13T23:31:13Z")

</div>

Try using lookups on top of a relation between the service and deliverables sheet to bring the right info to Services sheet. Then you can use that in your form, I believe.

---

<div class="post-metadata">

**Author:** ![NOBA\_Ventures](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/noba_ventures/32/14991_2.png) [@NOBA\_Ventures](https://community.glideapps.com/u/NOBA_Ventures)\
**Post date:** [April 14, 2021, 2:08pm UTC](https://community.glideapps.com/t/creating-relation-columns/25345/5 "2021-04-14T14:08:01Z")

</div>

@ThinhDinh using the glide unique formula I was able to create the correct relation between services and deliverables! Thanks 🙂