# Relate multiple rows in one table to 1 columns in another table **URL:** \ **Category:** Ask for Help\ **Created:** [March 23, 2023, 3:05pm UTC](https://community.glideapps.com/t/relate-multiple-rows-in-one-table-to-1-columns-in-another-table/59581 "2023-03-23T15:05:28Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Morten\_Sorensen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/morten_sorensen/32/56112_2.png) [@Morten\_Sorensen](https://community.glideapps.com/u/Morten_Sorensen)\ **Post date:** [March 23, 2023, 3:05pm UTC](https://community.glideapps.com/t/relate-multiple-rows-in-one-table-to-1-columns-in-another-table/59581/1 "2023-03-23T15:05:28Z")
Hi all of you… I want to have an app with 2 lists: users and courses, with the option of selection a specific user and choosing which courses he/she has been on (and vice versa). I have 2 tables: ‘users’ (with name and email) and ‘courses’ (with coursename and description). Is it possible to add another column in ‘users’ with the option of selecting muliple rows from ‘courses’? I can’t figure out to use relation when there is no identical data in the 2 tables. Should I use another datatype to connect the tables, or a third table? Thanks. Kind regards, Morten ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [March 23, 2023, 3:06pm UTC](https://community.glideapps.com/t/relate-multiple-rows-in-one-table-to-1-columns-in-another-table/59581/2 "2023-03-23T15:06:44Z")
You’d have to create a text column with a comma separated list of courses per user. Then, split the column to create an array of courses. Then relate the split text column to the courses table. ---
**Author:** ![Morten\_Sorensen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/morten_sorensen/32/56112_2.png) [@Morten\_Sorensen](https://community.glideapps.com/u/Morten_Sorensen)\ **Post date:** [March 23, 2023, 3:50pm UTC](https://community.glideapps.com/t/relate-multiple-rows-in-one-table-to-1-columns-in-another-table/59581/3 "2023-03-23T15:50:11Z")
Hi Robert, I managed to follow your description. But as I see it, I then have to update the commaspearated column in the sheet everytime a new course is added to a user, instead of having a checklist in the layout with the option of selection the courses he/she has been on? ---
**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:** [March 23, 2023, 4:31pm UTC](https://community.glideapps.com/t/relate-multiple-rows-in-one-table-to-1-columns-in-another-table/59581/4 "2023-03-23T16:31:42Z")
A choice component with a checklist style will write that comma delimited list of courses for you. ---
**Author:** ![Morten\_Sorensen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/morten_sorensen/32/56112_2.png) [@Morten\_Sorensen](https://community.glideapps.com/u/Morten_Sorensen)\ **Post date:** [March 23, 2023, 5:06pm UTC](https://community.glideapps.com/t/relate-multiple-rows-in-one-table-to-1-columns-in-another-table/59581/5 "2023-03-23T17:06:18Z")
Thanks both… It seems to work fine… ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [March 24, 2023, 5:06pm UTC](https://community.glideapps.com/t/relate-multiple-rows-in-one-table-to-1-columns-in-another-table/59581/6 "2023-03-24T17:06:58Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.