# Multiple to multiple **URL:** \ **Category:** Ask for Help\ **Created:** [December 31, 2020, 7:38am UTC](https://community.glideapps.com/t/multiple-to-multiple/20537 "2020-12-31T07:38:49Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Donny\_Lau](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/donny_lau/32/19029_2.png) [@Donny\_Lau](https://community.glideapps.com/u/Donny_Lau)\ **Post date:** [December 31, 2020, 7:38am UTC](https://community.glideapps.com/t/multiple-to-multiple/20537/1 "2020-12-31T07:38:49Z")
Hi, I’m building an app for a list of projects and the members involve in each project. Which means, one member can involve in multiple projects, and one project will have multiple members working on it. I can’t think of a proper way how to set up the relation in glide. Any help? Much appreciated! ---
**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:** [December 31, 2020, 7:48am UTC](https://community.glideapps.com/t/multiple-to-multiple/20537/2 "2020-12-31T07:48:17Z")
I think what you need here is a helper sheet where you store all assignments of member to projects. Let’s say it will have a project ID and an email of the assignee. Then in the Users sheet, create a relation using the email to the assignments sheet, you will have the multiple projects each person is involved in. In the Projects sheet, create a relation using the project ID, you will have the multiple members of the projects. ---
**Author:** ![Jacktools\_Net](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jacktools_net/32/18500_2.png) [@Jacktools\_Net](https://community.glideapps.com/u/Jacktools_Net)\ **Post date:** [December 31, 2020, 7:51am UTC](https://community.glideapps.com/t/multiple-to-multiple/20537/3 "2020-12-31T07:51:13Z")
You need a third table. In this you have the row id from the project as project id and the row id from the members as members id column. Than you can make related columns in project and menbers that relate to this third table with match multiple. ---
**Author:** ![Donny\_Lau](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/donny_lau/32/19029_2.png) [@Donny\_Lau](https://community.glideapps.com/u/Donny_Lau)\ **Post date:** [December 31, 2020, 9:43am UTC](https://community.glideapps.com/t/multiple-to-multiple/20537/4 "2020-12-31T09:43:21Z")
May I know how this helper table should be structured? Let says I have 2 projects and 5 members. For project A, I have 3 members involved; project B with 5 members. Should I put project ID in column A and members ID in Column B to D? ---
**Author:** ![Jacktools\_Net](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jacktools_net/32/18500_2.png) [@Jacktools\_Net](https://community.glideapps.com/u/Jacktools_Net)\ **Post date:** [December 31, 2020, 10:35am UTC](https://community.glideapps.com/t/multiple-to-multiple/20537/5 "2020-12-31T10:35:51Z")
You only need A and B Than a new row for each relation. ---
**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:** [December 31, 2020, 12:28pm UTC](https://community.glideapps.com/t/multiple-to-multiple/20537/6 "2020-12-31T12:28:40Z")
@Jacktools_Net is correct @Donny_Lau. It should be something like this. Project | Email Project A | [a@gmail.com](mailto:a@gmail.com) Project A | [b@gmail.com](mailto:b@gmail.com) ---
**Author:** ![profechef](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/profechef/32/221_2.png) [@profechef](https://community.glideapps.com/u/profechef)\ **Post date:** [December 31, 2020, 1:02pm UTC](https://community.glideapps.com/t/multiple-to-multiple/20537/7 "2020-12-31T13:02:00Z")
I’ve just posted a demo app in another thread which may suite your needs. It has only two tables [read it](https://community.glideapps.com/t/associate-multiple-rows-from-one-table-to-another-using-checklist/20534/17) ---
**Author:** ![Donny\_Lau](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/donny_lau/32/19029_2.png) [@Donny\_Lau](https://community.glideapps.com/u/Donny_Lau)\ **Post date:** [December 31, 2020, 1:16pm UTC](https://community.glideapps.com/t/multiple-to-multiple/20537/8 "2020-12-31T13:16:56Z")
Thanks @ThinhDinh and @Jacktools_Net! This solve my problem. Happy New Year! ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:58pm UTC](https://community.glideapps.com/t/multiple-to-multiple/20537/9 "2024-01-17T16:58:28Z")