# Relation from multiple values (Data)
**URL:** https://community.glideapps.com/t/relation-from-multiple-values-data/3945
**Category:** Feature Requests
**Created:** [January 24, 2020, 11:19pm UTC](https://community.glideapps.com/t/relation-from-multiple-values-data/3945 "2020-01-24T23:19:42Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@gshirato](https://community.glideapps.com/u/gshirato)
#### Post date: [January 24, 2020, 11:19pm UTC](https://community.glideapps.com/t/relation-from-multiple-values-data/3945/1 "2020-01-24T23:19:42Z")
Would be great if we could, in Configuration of Relation, set multiple values from multiple columns !?(for “Matches the value in:”)
thanks
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [January 25, 2020, 12:35am UTC](https://community.glideapps.com/t/relation-from-multiple-values-data/3945/2 "2020-01-25T00:35:16Z")
You can if you set up your columns as an array. For example, name the headings ‘Item 1’, ‘Item 2’, ‘Item 3’, etc. This will create a single ‘Item’ column that can be used to set up a relation using all ‘Item’ columns.
---
### Author:  [@gshirato](https://community.glideapps.com/u/gshirato)
#### Post date: [January 25, 2020, 6:54am UTC](https://community.glideapps.com/t/relation-from-multiple-values-data/3945/3 "2020-01-25T06:54:29Z")
Thank you for answering the question.
I am not sure if an array solves my problem.
I should have explained with an example.
Suppose that we have a datasets of football matches and there are two tables: `Team` and `Match`.
In `Team`, we have simply one column for `Name`.
In `Match`, we have match information such as `Home Name`, `Away Name`, `Date`, `Venue`, etc.
I want to use `Match`'s relation in `Team` for showing coming matches for a team in the team’s detail view.
For now, I can only refer to either of home/away column, so I should create two relations separately: `Home Relation` and `Away Relation`.
Therefore, I would like to create a relation that shows matches without filtering by home/away.
I actually wanted to ask if it is possible to set two conditions (see highlighted)
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [January 25, 2020, 12:03pm UTC](https://community.glideapps.com/t/relation-from-multiple-values-data/3945/4 "2020-01-25T12:03:35Z")
Check out this thread:
> [@How to create a relation which compares with multiple columns in other sheet](https://community.glideapps.com/t/how-to-create-a-relation-which-compares-with-multiple-columns-in-other-sheet/2592):
>
> I need to solve this: Sheet A (games) has 2 Columns with, “Home team ID” and “Away Team ID” Sheet B (Teams) has a column with “ID of the team” I want to relate Teams to the games their in in ONE list. So I need relate Teams to 2 colums of Games which both can contain the team ID. Does anyone know a fix? Having a new sheet with a beast of an array-kind-of-formula is also good if this fixes it XD To [SmartSelect\_20191203-113729\_Sheets]
---
### Author:  [@gshirato](https://community.glideapps.com/u/gshirato)
#### Post date: [January 25, 2020, 12:50pm UTC](https://community.glideapps.com/t/relation-from-multiple-values-data/3945/5 "2020-01-25T12:50:19Z")
Oh, I did not realize that we could make an array as a part of table!
Thanks so much!
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [May 19, 2024, 4:09am UTC](https://community.glideapps.com/t/relation-from-multiple-values-data/3945/6 "2024-05-19T04:09:55Z")