# Choice and Lookup **URL:** \ **Category:** Ask for Help\ **Created:** [January 12, 2022, 2:07am UTC](https://community.glideapps.com/t/choice-and-lookup/37060 "2022-01-12T02:07:54Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Wander\_Ferreira](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wander_ferreira/32/26408_2.png) [@Wander\_Ferreira](https://community.glideapps.com/u/Wander_Ferreira)\ **Post date:** [January 12, 2022, 2:07am UTC](https://community.glideapps.com/t/choice-and-lookup/37060/1 "2022-01-12T02:07:54Z")
Here, when I select more than two items in Choice, my worksheet is blank in that specific cell where it should have two Row IDs. Also the [Title] in the [Details] item is not recognizing the Lookup column. I remember that I recognized it and now it isn’t. ---
**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:** [January 12, 2022, 3:39am UTC](https://community.glideapps.com/t/choice-and-lookup/37060/2 "2022-01-12T03:39:44Z")
Can you attach a video or some screenshots of the supposed bug? Thank you. ---
**Author:** ![Wander\_Ferreira](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wander_ferreira/32/26408_2.png) [@Wander\_Ferreira](https://community.glideapps.com/u/Wander_Ferreira)\ **Post date:** [January 12, 2022, 1:15pm UTC](https://community.glideapps.com/t/choice-and-lookup/37060/3 "2022-01-12T13:15:22Z")
Image 01: ![Captura de tela 2022-01-12 095900](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/0/a02462e2143999ca424e18cc8cf1a879bd5fd932.png) Yes, first correcting the message above, in fact in the column [FK ID Categoria] appears the two Rows ID referring to the Categories table (image 01) when I select more than one option in Choice. Image 02: ![Captura de tela 2022-01-12 100122](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/7/c78286d83757469e31179088e155bbeb6bd82efe.png) In image 02, see that the Relation, even with Match Multiple activated, is not returning the information. Lookup is also not returning any information. Note that I have marked with an arrow in the specific cell in the columns respectively. Image 03: ![Captura de tela 2022-01-12 100200](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/f/cf73db7ef12745adf4f2e1776b7406ba470858ac.png) In image 03 [Title] doesn’t recognize the Lookup in [Details], even if I don’t use Match Multiple in Relation. ---
**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:** [January 12, 2022, 1:44pm UTC](https://community.glideapps.com/t/choice-and-lookup/37060/4 "2022-01-12T13:44:25Z")
First of all, your FK ID Categoria column is a basic text column. Unless your relation finds an exact match in your related table (another column that also contains to ID’s separated by a comma), then it is not going to find anything. Instead you need to use a Split Text column to split the comma separated list of ID’s into an array. Then use that array in you relation column. That way the relation can properly check each individual ID to see if there is a match. In summary, create a Split Text column and use that in your relation. If you intend to use a Lookup in a Title component, then it does need to be from a single relation (multiple unchecked). Although, I’m not sure how you intend to have multiple ID’s return multiple matching rows with multiple Lookups and display that in a Title component that’s capable of displaying only a single value. ---
**Author:** ![Wander\_Ferreira](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wander_ferreira/32/26408_2.png) [@Wander\_Ferreira](https://community.glideapps.com/u/Wander_Ferreira)\ **Post date:** [January 12, 2022, 6:19pm UTC](https://community.glideapps.com/t/choice-and-lookup/37060/5 "2022-01-12T18:19:23Z")
Thanks for the information. I forgot about SplitText. There are times when an item can be in two categories at the same time. In Title it is not so important to show which categories belong. In the List, yes, because they will be Inline Lists with specific filters by categories. ---
**Author:** ![Wander\_Ferreira](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wander_ferreira/32/26408_2.png) [@Wander\_Ferreira](https://community.glideapps.com/u/Wander_Ferreira)\ **Post date:** [January 12, 2022, 6:24pm UTC](https://community.glideapps.com/t/choice-and-lookup/37060/6 "2022-01-12T18:24:28Z")
I’ll trade the Bug for Help! And thanks for the information. ---
**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:** [January 13, 2022, 6:25pm UTC](https://community.glideapps.com/t/choice-and-lookup/37060/7 "2022-01-13T18:25:27Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.