# Tricked by a "Split + Multiple relation + Lookup" **URL:** \ **Category:** Ask for Help\ **Created:** [April 19, 2021, 5:13pm UTC](https://community.glideapps.com/t/tricked-by-a-split-multiple-relation-lookup/25774 "2021-04-19T17:13:47Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\ **Post date:** [April 19, 2021, 5:13pm UTC](https://community.glideapps.com/t/tricked-by-a-split-multiple-relation-lookup/25774/1 "2021-04-19T17:13:48Z")
Hi, I am struggling with a combo of split, multiple relation and lookup… As illustrated in the picture below, the objective is to - table [company]: assign some “advisor(s)” to a company, knowing that 1 advisor can be in several companies - table [user]: find the company(ies) assigned to each advisor. I don’t get why the Lookup function does not work, while the Relation works…? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/3/330b155e99fdcad650b142376afd029d3e8f43be.png) Many thanks for your insights ---
**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 19, 2021, 6:31pm UTC](https://community.glideapps.com/t/tricked-by-a-split-multiple-relation-lookup/25774/2 "2021-04-19T18:31:57Z")
So the relation does have the proper matches, but the lookup is completely empty? Have you selected or unselected the multiple flag in the past? Have you renamed any columns in the past? What happens if you create a new relation column and a new lookup column? ---
**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\ **Post date:** [April 19, 2021, 7:54pm UTC](https://community.glideapps.com/t/tricked-by-a-split-multiple-relation-lookup/25774/3 "2021-04-19T19:54:37Z")
Did what you recommand (re-create Relation & Lookup) and magic, it works! So weird. Thank you @Jeff_Hager ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/8/1800c04da059e0b7d445e6db61f09369190d9aab.png) ---
**Author:** ![Jim\_McIntosh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jim_mcintosh/32/19235_2.png) [@Jim\_McIntosh](https://community.glideapps.com/u/Jim_McIntosh)\ **Post date:** [April 19, 2021, 9:46pm UTC](https://community.glideapps.com/t/tricked-by-a-split-multiple-relation-lookup/25774/4 "2021-04-19T21:46:32Z")
Ha, mentally bookmarking this . ---
**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 19, 2021, 10:35pm UTC](https://community.glideapps.com/t/tricked-by-a-split-multiple-relation-lookup/25774/5 "2021-04-19T22:35:11Z")
It used to be a lot worse, but on rare occasions, it seems that renaming a column or changing the multiple flag after the column has been created seems to put it in a partially broken state. Not sure why, but recreating the columns seems to take care of it. Glad that worked for you. ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:52pm UTC](https://community.glideapps.com/t/tricked-by-a-split-multiple-relation-lookup/25774/6 "2024-01-17T16:52:32Z")