# Can't see relation in single item view **URL:** \ **Category:** Ask for Help\ **Created:** [August 20, 2024, 3:40pm UTC](https://community.glideapps.com/t/cant-see-relation-in-single-item-view/75742 "2024-08-20T15:40:43Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![jonovd](https://avatars.discourse-cdn.com/v4/letter/j/ebca7d/32.png) [@jonovd](https://community.glideapps.com/u/jonovd)\ **Post date:** [August 20, 2024, 3:40pm UTC](https://community.glideapps.com/t/cant-see-relation-in-single-item-view/75742/1 "2024-08-20T15:40:43Z")
I’m pretty sure I’m missing something basic here. I have a tasks table and a status table, and I’m relating task statuses with statusIDs (row IDs), which appear as the status name in the Task table. For the collection, the status relation can be selected as one of the columns, so it shows the status name not the status ID. But when I click on the individual tasks, I can’t select the status relation column as a field, so it’s just showing the statusID. What am I missing? ![CleanShot 2024-08-20 at 17.31.24](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/8/a870934710963d3a19e67a712d0071e62c86a5a4.jpeg) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [August 20, 2024, 3:44pm UTC](https://community.glideapps.com/t/cant-see-relation-in-single-item-view/75742/2 "2024-08-20T15:44:06Z")
You can’t use a relation column in a fields component . Assuming the relation is a single relation, what you probably want is a lookup column that fetches the value you need via the relation. ---
**Author:** ![jonovd](https://avatars.discourse-cdn.com/v4/letter/j/ebca7d/32.png) [@jonovd](https://community.glideapps.com/u/jonovd)\ **Post date:** [August 20, 2024, 3:46pm UTC](https://community.glideapps.com/t/cant-see-relation-in-single-item-view/75742/3 "2024-08-20T15:46:16Z")
Thanks for the quick response. So I effectively have the status data duplicated 3 times now? This surely isn’t right… ![CleanShot 2024-08-20 at 17.45.34](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/6/f6db280c13e626ddd132181f83de50e1ced6d740.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [August 20, 2024, 3:59pm UTC](https://community.glideapps.com/t/cant-see-relation-in-single-item-view/75742/4 "2024-08-20T15:59:19Z")
It’s almost right. Looks like your relation is a multiple relation, which means that your lookup is returning an array (you can tell it’s an array because of the bubble around the value), so you still won’t be able to use it in the Fields component. You need to do one of two things: - If you only expect the relation to ever match one row, then you should change it to a single relation. Then you will be able to use the lookup. - If the relation could match multiple rows, then instead of using a lookup you should use a single value column. I know it seems a bit convoluted, but this is how Glide works. Essentially what you are looking for/expecting is what we refer to as an Inline Lookup. This is not something that Glide supports, unfortunately. Maybe one day… ---
**Author:** ![jonovd](https://avatars.discourse-cdn.com/v4/letter/j/ebca7d/32.png) [@jonovd](https://community.glideapps.com/u/jonovd)\ **Post date:** [August 20, 2024, 4:05pm UTC](https://community.glideapps.com/t/cant-see-relation-in-single-item-view/75742/5 "2024-08-20T16:05:31Z")
Yes that’s right, I was seeing if making it multiple would solve the issue. Will revert that back. We will eventually move over to Postgres (via Supabase) but wanted to build out the core UI with Glide tables - so I’m effectively trying to replicate the relational DB (foreign key \<\> primary key) in Glide. I imagine there was a good reason it was built like this… ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [August 20, 2024, 4:07pm UTC](https://community.glideapps.com/t/cant-see-relation-in-single-item-view/75742/6 "2024-08-20T16:07:52Z")
It’s a long term feature request - see below. > [@Select values from relations just like "User \>" (Inline Lookups)](https://community.glideapps.com/t/select-values-from-relations-just-like-user-inline-lookups/26092): > > Just like we can choose a value from a user profile sheet during if/then/else columns, template columns, filtering/visibility conditions, etc, would love to be able to do the same via relations. It would cut down on SO MUCH app bloat. @david @mark @tristan Here’s a mockup: Glide have indicated that they would like to do it, but I get the impression that it’s not a high priority. ---
**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:** [August 27, 2024, 4:08pm UTC](https://community.glideapps.com/t/cant-see-relation-in-single-item-view/75742/7 "2024-08-27T16:08:50Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.