# Data Editor population issue **URL:** \ **Category:** Ask for Help\ **Created:** [February 17, 2020, 4:59am UTC](https://community.glideapps.com/t/data-editor-population-issue/4664 "2020-02-17T04:59:28Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Perrin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/perrin/32/2830_2.png) [@Perrin](https://community.glideapps.com/u/Perrin)\ **Post date:** [February 17, 2020, 4:59am UTC](https://community.glideapps.com/t/data-editor-population-issue/4664/1 "2020-02-17T04:59:28Z")
Using a sheet that has data pulled in from a relationship column in the data editor with more than one look up column from the data editor. only the columns in the google sheet are coming into the components list. Thanks. ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [February 17, 2020, 5:07am UTC](https://community.glideapps.com/t/data-editor-population-issue/4664/2 "2020-02-17T05:07:50Z")
Can you show us with pictures? I don’t follow. ---
**Author:** ![Perrin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/perrin/32/2830_2.png) [@Perrin](https://community.glideapps.com/u/Perrin)\ **Post date:** [February 17, 2020, 5:23am UTC](https://community.glideapps.com/t/data-editor-population-issue/4664/3 "2020-02-17T05:23:36Z")
Yes, I attaches the screen shot of what is showing in the comment editor. Second is what is in data editor that should be available. I only shared the headers to minimize grab. ![Screen Shot 2020-02-16 at 9.21.37 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/419c95dd97c7d50cf6d6db9cf7020ba21e1aaa69.png) ![Screen Shot 2020-02-16 at 9.21.59 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/048d6a329945dab82d26ca0664cc06226eef5955.png) Thank you. ---
**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:** [February 17, 2020, 9:47am UTC](https://community.glideapps.com/t/data-editor-population-issue/4664/4 "2020-02-17T09:47:50Z")
I’m guessing you have ‘multiple’ selected in your relation. This changes all attached lookup columns into columns that are meant to contain an array of multiple values. You can’t put multiple values into a component that can only hold one value. You need to uncheck the multiple checkbox in the relation column settings. You may or may not have to set up all of your lookups again after doing this. ---
**Author:** ![Perrin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/perrin/32/2830_2.png) [@Perrin](https://community.glideapps.com/u/Perrin)\ **Post date:** [February 18, 2020, 1:58am UTC](https://community.glideapps.com/t/data-editor-population-issue/4664/5 "2020-02-18T01:58:12Z")
I have a relationship column brining in data, and then using a look up to pull one piece of data into that column. None of those appear. I have the process working on a different sheet for another screen/component. ---
**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:** [February 18, 2020, 2:41am UTC](https://community.glideapps.com/t/data-editor-population-issue/4664/6 "2020-02-18T02:41:48Z")
Yes, I get that, but is it a multiple or a single relation? ---
**Author:** ![Perrin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/perrin/32/2830_2.png) [@Perrin](https://community.glideapps.com/u/Perrin)\ **Post date:** [February 18, 2020, 3:38am UTC](https://community.glideapps.com/t/data-editor-population-issue/4664/7 "2020-02-18T03:38:59Z")
Multiple. Though I have it set up that way to manage a categories list and relationship back to that sheet. Thanks. ---
**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:** [February 18, 2020, 4:19am UTC](https://community.glideapps.com/t/data-editor-population-issue/4664/8 "2020-02-18T04:19:47Z")
Lookups capable of containing multiple values will not work in components that can only contain single values. If you still need to have a multiple relation, I would recommend creating a second single relation and creating your lookup columns off of that. ---
**Author:** ![Perrin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/perrin/32/2830_2.png) [@Perrin](https://community.glideapps.com/u/Perrin)\ **Post date:** [February 18, 2020, 4:40am UTC](https://community.glideapps.com/t/data-editor-population-issue/4664/9 "2020-02-18T04:40:55Z")
Thanks, I will have to see what will work. I am brining in data where I need the more than one to return as they are locations matching back to a business.