# Inconsistent behavior of Lookup column?

**URL:** https://community.glideapps.com/t/inconsistent-behavior-of-lookup-column/62443
**Category:** Ask for Help
**Created:** [June 4, 2023, 10:39pm UTC](https://community.glideapps.com/t/inconsistent-behavior-of-lookup-column/62443 "2023-06-04T22:39:59Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Tamara\_Didenko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tamara_didenko/32/42215_2.png) [@Tamara\_Didenko](https://community.glideapps.com/u/Tamara_Didenko)
#### Post date: [June 4, 2023, 10:39pm UTC](https://community.glideapps.com/t/inconsistent-behavior-of-lookup-column/62443/1 "2023-06-04T22:39:59Z")

</div>

Confused by this behavior and looking for ideas for troubleshooting!

I have three tables:

- A: Glide table
- B: Glide table
- C: Artable + some glide columns

Table C is related to both A & B tables through a normal relation. I have a lookup column in Table C, which is currently looking at a user-specific Text column in Table A. I have the same user-specific Text column in Table B. I’m trying to switch lookup from Table A to Table B. However, a lookup from Table A returns just normal text, while a lookup from Table B returns a single-value array 🤔

Why could this be happening? I can’t pinpoint any differences in those columns – both are set by a similar action, both are text, and both are user-specific. What could be going on?

Edit: this is a Classic App

---

<div class="post-metadata">

### 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: [June 4, 2023, 10:46pm UTC](https://community.glideapps.com/t/inconsistent-behavior-of-lookup-column/62443/2 "2023-06-04T22:46:07Z")

</div>

Possibly your relation to table B is Multiple instead of single. I think that might cause it to return a single value array

---

<div class="post-metadata">

### Author: ![Tamara\_Didenko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tamara_didenko/32/42215_2.png) [@Tamara\_Didenko](https://community.glideapps.com/u/Tamara_Didenko)
#### Post date: [June 4, 2023, 10:47pm UTC](https://community.glideapps.com/t/inconsistent-behavior-of-lookup-column/62443/3 "2023-06-04T22:47:10Z")

</div>

Nope, they are both one-to-one relations

---

<div class="post-metadata">

### 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: [June 4, 2023, 11:41pm UTC](https://community.glideapps.com/t/inconsistent-behavior-of-lookup-column/62443/4 "2023-06-04T23:41:09Z")

</div>

Can you add some screenshots?

---

<div class="post-metadata">

### Author: ![Tamara\_Didenko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tamara_didenko/32/42215_2.png) [@Tamara\_Didenko](https://community.glideapps.com/u/Tamara_Didenko)
#### Post date: [June 4, 2023, 11:54pm UTC](https://community.glideapps.com/t/inconsistent-behavior-of-lookup-column/62443/5 "2023-06-04T23:54:16Z")

</div>

Must have been some sort of a glitch. Now it works as expected.

Sorry for the disturbance 😅

---

<div class="post-metadata">

### 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: [June 5, 2023, 11:54pm UTC](https://community.glideapps.com/t/inconsistent-behavior-of-lookup-column/62443/6 "2023-06-05T23:54:52Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
