# Stuck on select lists **URL:** \ **Category:** Ask for Help\ **Created:** [April 24, 2023, 12:31pm UTC](https://community.glideapps.com/t/stuck-on-select-lists/60916 "2023-04-24T12:31:32Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![jjj111](https://avatars.discourse-cdn.com/v4/letter/j/48db29/32.png) [@jjj111](https://community.glideapps.com/u/jjj111)\ **Post date:** [April 24, 2023, 12:31pm UTC](https://community.glideapps.com/t/stuck-on-select-lists/60916/1 "2023-04-24T12:31:32Z")
I am new to Glide but old to programming. This software is so slick but I can’t for the life of me figure out how to do a simple select list from another table. I have “Items”. One of the fields is “Category”, so I made a Categories table. Categories only has “id” and “name”. In “Items”, I have “Category”, which I have set to accept “category\_id”, which is easy to set when creating a new Picker with the display as Name and value as ID. But… when I go to acess Category for a specific Item, it only displays the ID, rather than allowing it to grab the related Name. So, for instance, my filter looks like this: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/4/64ba3091d8e546367f827238a5e61181a13756fb.png) I figured maybe there is a “Computed” type for category\_id, but those just seem to grab the raw data, rather than creating a related table. Tried all I can think of…and I am now stuck. Any advice is helpful! ---
**Author:** ![Lucas\_Malguy1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_malguy1/32/54607_2.png) [@Lucas\_Malguy1](https://community.glideapps.com/u/Lucas_Malguy1)\ **Post date:** [April 24, 2023, 12:59pm UTC](https://community.glideapps.com/t/stuck-on-select-lists/60916/2 "2023-04-24T12:59:02Z")
Hi, on your option panel on the right side of you Glide editor, you can select the filters and replace ID by Names 🙂 ![Capture d’écran 2023-04-24 à 14.58.01](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/d/bdfa2a8dfb22864b077cae21158246abeec18528.jpeg) ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [April 24, 2023, 1:01pm UTC](https://community.glideapps.com/t/stuck-on-select-lists/60916/3 "2023-04-24T13:01:59Z")
Hello and welcome to the community 🥳 In case the Name is not in that table what you could do is create a SINGLE Relation from the ID in your Items table to the ID in your Categories table and then use a Lookup Column via that Relation to return the Name. Finally use that Lookup Column as the source of your filter. ---
**Author:** ![jjj111](https://avatars.discourse-cdn.com/v4/letter/j/48db29/32.png) [@jjj111](https://community.glideapps.com/u/jjj111)\ **Post date:** [April 24, 2023, 1:12pm UTC](https://community.glideapps.com/t/stuck-on-select-lists/60916/4 "2023-04-24T13:12:10Z")
@lucas: thank you. The problem is… the data in the column is the category\_id. And there doesn’t seem to be a way to show a different value via lookup? @eric: thanks. So you’re saying in my Items table, I would have two columns: “category\_name” (single relation to grab the name) AND "category\_id"which holds the relation id? ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [April 24, 2023, 1:16pm UTC](https://community.glideapps.com/t/stuck-on-select-lists/60916/5 "2023-04-24T13:16:46Z")
2 columns total… a relation and a lookup > [@jjj111](#): > > In “Items”, I have “Category”, which I have set to accept “category\_id”, Create a Single relation between this ID column in the items table and the ID column in your categories table. Next add a lookup column, use the relation above and return the Name column. This should put the name of your categories on each row of your Items table. Finally in the right hand side of the layout editor change your filter to use that new lookup column. ---
**Author:** ![jjj111](https://avatars.discourse-cdn.com/v4/letter/j/48db29/32.png) [@jjj111](https://community.glideapps.com/u/jjj111)\ **Post date:** [April 24, 2023, 1:42pm UTC](https://community.glideapps.com/t/stuck-on-select-lists/60916/6 "2023-04-24T13:42:01Z")
Ok. So I have these two columns now in Items: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/e/ae66d9fc04ca6167658dd7148962a975ebb55d22.png) The ID is being added automatically via record create. And then \_name is using a RELATION to grab the name. This seems a bit clunky but it works. However…when I go to create a filter, category\_name is not an available option. I am guessing because it is a "computed’ column type. ---
**Author:** ![jjj111](https://avatars.discourse-cdn.com/v4/letter/j/48db29/32.png) [@jjj111](https://community.glideapps.com/u/jjj111)\ **Post date:** [April 24, 2023, 1:42pm UTC](https://community.glideapps.com/t/stuck-on-select-lists/60916/7 "2023-04-24T13:42:37Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/a/faedcb8b2335ded7657c799bb077b1874708ff42.png) ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [April 24, 2023, 1:45pm UTC](https://community.glideapps.com/t/stuck-on-select-lists/60916/8 "2023-04-24T13:45:44Z")
Where is your lookup column? We need to configure a lookup column via that relation and return the name. FYI the relation is not returning the name… it’s simply showing you that there is a match. In this instance the relation so happens to be displaying the Name column by chance. ---
**Author:** ![jjj111](https://avatars.discourse-cdn.com/v4/letter/j/48db29/32.png) [@jjj111](https://community.glideapps.com/u/jjj111)\ **Post date:** [April 24, 2023, 2:08pm UTC](https://community.glideapps.com/t/stuck-on-select-lists/60916/9 "2023-04-24T14:08:11Z")
I don’t know why I can’t wrap my head around this 🤣 Schema: **Items** id name category\_id → RELATION to “id” in “categories” table category\_name → LOOKUP to category\_id? I do not see anywhere in the LOOKUP settings to tell it to return name … ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/d/fd1dffa11fb5dc7f94ca15ec03cad50feefb32f1.png) ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [April 24, 2023, 2:09pm UTC](https://community.glideapps.com/t/stuck-on-select-lists/60916/10 "2023-04-24T14:09:58Z")
In your configuration change the “Relation column:” to the new relation we created then select the name column. ---
**Author:** ![jjj111](https://avatars.discourse-cdn.com/v4/letter/j/48db29/32.png) [@jjj111](https://community.glideapps.com/u/jjj111)\ **Post date:** [April 24, 2023, 2:14pm UTC](https://community.glideapps.com/t/stuck-on-select-lists/60916/11 "2023-04-24T14:14:37Z")
I wiped category and am trying again. To create the first CategoryID relation column, these are the options I am given. What do I select here? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/9/e918f49c616eb5e9c62fb32437cbff6ed4199811.png) ---
**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:** [April 24, 2023, 2:20pm UTC](https://community.glideapps.com/t/stuck-on-select-lists/60916/12 "2023-04-24T14:20:21Z")
Your relation was fine as it was. You need to correct your Lookup column to use the relation. You have it configured to use the entire table instead of the relation. A Relation establishes the link to rows in the related table. The Lookup retrieves specific column values from that relation. ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [April 24, 2023, 2:37pm UTC](https://community.glideapps.com/t/stuck-on-select-lists/60916/13 "2023-04-24T14:37:15Z")
Here have a look ---
**Author:** ![jjj111](https://avatars.discourse-cdn.com/v4/letter/j/48db29/32.png) [@jjj111](https://community.glideapps.com/u/jjj111)\ **Post date:** [April 25, 2023, 7:32pm UTC](https://community.glideapps.com/t/stuck-on-select-lists/60916/14 "2023-04-25T19:32:26Z")
That was so helpful. MUCH appreciated!