# Relation between two sheet

**URL:** <https://community.glideapps.com/t/relation-between-two-sheet/70714>\
**Category:** Ask for Help\
**Created:** [February 11, 2024, 11:20am UTC](https://community.glideapps.com/t/relation-between-two-sheet/70714 "2024-02-11T11:20:15Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![theo\_180280](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/theo_180280/32/50049_2.png) [@theo\_180280](https://community.glideapps.com/u/theo_180280)\
**Post date:** [February 11, 2024, 11:20am UTC](https://community.glideapps.com/t/relation-between-two-sheet/70714/1 "2024-02-11T11:20:15Z")

</div>

bonjour j ai cree une application pour la maintenance,mon maintenancié peut cree des fiches d interventions, il peut aussi ajouter une commande materiels .je souhaiterai voir toutes ces infos sur la fiche details d intervention.merci

---

<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:** [February 11, 2024, 11:30am UTC](https://community.glideapps.com/t/relation-between-two-sheet/70714/2 "2024-02-11T11:30:19Z")

</div>

You need a common value in each table that can be used to create a relation between the two. That’s about as specific as I can be based on the information that you shared.

> **[Relations | Glide Docs](https://www.glideapps.com/docs/automation/computed-columns/relations)**
>
> Create relationships and link rows together.

---

<div class="post-metadata">

**Author:** ![theo\_180280](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/theo_180280/32/50049_2.png) [@theo\_180280](https://community.glideapps.com/u/theo_180280)\
**Post date:** [February 11, 2024, 3:33pm UTC](https://community.glideapps.com/t/relation-between-two-sheet/70714/3 "2024-02-11T15:33:58Z")

</div>

j ai un fichier google sheet avec 4 feuilles (commande,produit,interventions,users).le but c est que l utilisateur cree une fiche interventions puisse aussi ajouter une commande de produit.et quand je regarde la fiche d intervention je puisse voir les produit commande aussi.

---

<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:** [February 11, 2024, 3:38pm UTC](https://community.glideapps.com/t/relation-between-two-sheet/70714/4 "2024-02-11T15:38:37Z")

</div>

Okay, so you will need an OrderID column in your Intervention table. You should populate this column with the correct OrderID whenever a new row is added. You can then use that to create a relation to your Orders table.

---

<div class="post-metadata">

**Author:** ![theo\_180280](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/theo_180280/32/50049_2.png) [@theo\_180280](https://community.glideapps.com/u/theo_180280)\
**Post date:** [February 11, 2024, 3:40pm UTC](https://community.glideapps.com/t/relation-between-two-sheet/70714/5 "2024-02-11T15:40:17Z")

</div>

do you have exemple

---

<div class="post-metadata">

**Author:** ![theo\_180280](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/theo_180280/32/50049_2.png) [@theo\_180280](https://community.glideapps.com/u/theo_180280)\
**Post date:** [February 11, 2024, 3:41pm UTC](https://community.glideapps.com/t/relation-between-two-sheet/70714/6 "2024-02-11T15:41:13Z")

</div>

because i have column id

---

<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:** [February 11, 2024, 3:51pm UTC](https://community.glideapps.com/t/relation-between-two-sheet/70714/7 "2024-02-11T15:51:32Z")

</div>

If you show me screenshots of both tables (from the Glide Data Editor), I can probably give some more specific guidance.

Also, can you explain a little more how rows are currently added to each table?

---

<div class="post-metadata">

**Author:** ![theo\_180280](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/theo_180280/32/50049_2.png) [@theo\_180280](https://community.glideapps.com/u/theo_180280)\
**Post date:** [February 11, 2024, 4:02pm UTC](https://community.glideapps.com/t/relation-between-two-sheet/70714/8 "2024-02-11T16:02:29Z")

</div>

for add row i use button form