# Lookup with a multiple relation column
**URL:** https://community.glideapps.com/t/lookup-with-a-multiple-relation-column/1378
**Category:** Ask for Help
**Created:** [October 25, 2019, 8:40am UTC](https://community.glideapps.com/t/lookup-with-a-multiple-relation-column/1378 "2019-10-25T08:40:04Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@Olivier\_Gibier](https://community.glideapps.com/u/Olivier_Gibier)
#### Post date: [October 25, 2019, 8:40am UTC](https://community.glideapps.com/t/lookup-with-a-multiple-relation-column/1378/1 "2019-10-25T08:40:04Z")
I’d like to add a lookup column with a multiple relation column, is it possible ?
My case of use :
- sheet “users rights” with 2 columns “project” and “user email”. I can have many rows with different users email for the same project.
- sheet “project”
I’d want add a lookup column in the project’s sheet with all the email authorized for the project. Then, i could have a tab in my app with per-user-data based on this lookup column.
I hope my request is clear.
---
### Author:  [@JackVaughan](https://community.glideapps.com/u/JackVaughan)
#### Post date: [October 25, 2019, 12:10pm UTC](https://community.glideapps.com/t/lookup-with-a-multiple-relation-column/1378/2 "2019-10-25T12:10:44Z")
Hi there Oliver, @Mark and I were just talking about this yesterday. At the moment you can’t do this but we definitely want to make that possible in future.
Mark - if you have any suggestions for @Olivier_Gibier that would be awesome.
---
### Author:  [@Olivier\_Gibier](https://community.glideapps.com/u/Olivier_Gibier)
#### Post date: [October 25, 2019, 12:33pm UTC](https://community.glideapps.com/t/lookup-with-a-multiple-relation-column/1378/3 "2019-10-25T12:33:13Z")
Yes, i think it’s a good way to manage rights user or groups.
---
### Author:  [@Mark](https://community.glideapps.com/u/Mark)
#### Post date: [October 25, 2019, 12:48pm UTC](https://community.glideapps.com/t/lookup-with-a-multiple-relation-column/1378/4 "2019-10-25T12:48:16Z")
Yes, that makes total sense.
---
### Author:  [@JackVaughan](https://community.glideapps.com/u/JackVaughan)
#### Post date: [November 11, 2019, 5:26pm UTC](https://community.glideapps.com/t/lookup-with-a-multiple-relation-column/1378/5 "2019-11-11T17:26:48Z")
This is now possible - in the image below you can see a multiple relation and then a lookup column that pulls back all the users who are allowed access to this project. (tutorial coming soon)
---
### Author:  [@moses5407](https://community.glideapps.com/u/moses5407)
#### Post date: [February 2, 2020, 7:10am UTC](https://community.glideapps.com/t/lookup-with-a-multiple-relation-column/1378/6 "2020-02-02T07:10:42Z")
Look great … but that goes by pretty fast. Can you do a slower animation or share the user projects app?
---
### Author:  [@JackVaughan](https://community.glideapps.com/u/JackVaughan)
#### Post date: [February 2, 2020, 1:18pm UTC](https://community.glideapps.com/t/lookup-with-a-multiple-relation-column/1378/7 "2020-02-02T13:18:50Z")
Hey @moses5407 - I just looked in my folders and can’t find the example app I made for this GIF. I may have tidied it into the trash at some point.
Also - I said tutorial coming ‘soon’, - still on my list! 😉 sorry!
Essentially:
- create a list of projects in **sheet1**
- create a column called user which will assign a users email to that row
- you may create multiple duplicate entries of a project so you can assign it to different users using the email column eg:
Row1: Project A | [john@gmail.com](mailto:john@gmail.com)
Row2: Project A | [sarah@gmail.com](mailto:sarah@gmail.com)
Row3: Project B | [mary@gmail.com](mailto:mary@gmail.com)
Row4: Project A | [mary@gmail.com](mailto:mary@gmail.com)
Row5: Project C | [john@gmail.com](mailto:john@gmail.com)
- then create a list of projects in **sheet2** but with no duplication (i.e. a unique list of projects)
Row1: Project A
Row2: Project B
Row3: Project C
- Then create a [multi relation](https://docs.glideapps.com/all/guides/quick-starts/intermediate-techniques/match-multiple-relations) from **sheet2** back to **sheet1** to pull in all the instances of each project.
- Then create a lookup column that looks through that relation and pulls back all the users that are ‘authorized’ for that project.
Let me know if you have any q’s
---
### Author:  [@moses5407](https://community.glideapps.com/u/moses5407)
#### Post date: [February 2, 2020, 4:04pm UTC](https://community.glideapps.com/t/lookup-with-a-multiple-relation-column/1378/8 "2020-02-02T16:04:24Z")
Thanks, Jack! The support here is second to none!
---
### Author:  [@moses5407](https://community.glideapps.com/u/moses5407)
#### Post date: [February 10, 2020, 1:09pm UTC](https://community.glideapps.com/t/lookup-with-a-multiple-relation-column/1378/9 "2020-02-10T13:09:33Z")
Hi, Jack. I posted this in feature requests but wanted to also bring it up directly to you.
"If it’s helpful, here’s a link to an HTML5 in-browser QRcode scanner:
[https://github.com/schmich/instascan](https://github.com/schmich/instascan).
I’d also be open to contributing financially, if I can afford it, for this as well as a input type range slider component.
[https://www.html5tutorial.info/html5-range.php](https://www.html5tutorial.info/html5-range.php)"
My interest is to have a QRCode reader and input range slider which I think would be helpful for many others as well.