# How do I pick another field from a connection?

**URL:** <https://forums.knack.com/t/how-do-i-pick-another-field-from-a-connection/7205>\
**Category:** Get Answers\
**Created:** [January 9, 2018, 12:54pm UTC](https://forums.knack.com/t/how-do-i-pick-another-field-from-a-connection/7205 "2018-01-09T12:54:48Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![GuidoJanse18125](https://avatars.discourse-cdn.com/v4/letter/g/8e8cbc/32.png) [@GuidoJanse18125](https://forums.knack.com/u/GuidoJanse18125)\
**Post date:** [January 9, 2018, 12:54pm UTC](https://forums.knack.com/t/how-do-i-pick-another-field-from-a-connection/7205/1 "2018-01-09T12:54:48Z")

</div>

I have 2 Objects: Companies and Countries.

Countries contain 2 fields: Name (text) and Flag (image)

When adding a Company, users need to select the Country name from a dropdown.

When making a Company page, I would like to show the Country Flag instead of it's name.

Is this possible and if so: how?

---

<div class="post-metadata">

**Author:** ![JulianKirkness](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/juliankirkness/32/770_2.png) [@JulianKirkness](https://forums.knack.com/u/JulianKirkness)\
**Post date:** [January 24, 2018, 12:24pm UTC](https://forums.knack.com/t/how-do-i-pick-another-field-from-a-connection/7205/2 "2018-01-24T12:24:18Z")

</div>

There is a simple solution to this - in the builder, when building a Table or Detail View, you have the option to pick fields from connected objects:

 ![](https://support.knack.com/hc/user_images/Z-RiWaTxTQbY0lICYJ7XsA.png)

From this you end up with a view which displays the image:

 ![](https://support.knack.com/hc/user_images/5eKopmPLC9F5fzk-Uf_aJA.png)

(Ignore the actual database, it's just one I use to test out stuff!)

Hope this helps!

Julian

---

<div class="post-metadata">

**Author:** ![JulianSwal22288](https://avatars.discourse-cdn.com/v4/letter/j/8c91f0/32.png) [@JulianSwal22288](https://forums.knack.com/u/JulianSwal22288)\
**Post date:** [January 18, 2018, 2:57am UTC](https://forums.knack.com/t/how-do-i-pick-another-field-from-a-connection/7205/3 "2018-01-18T02:57:58Z")

</div>

I've played with this a bit now.. You can access the other field with Country.Flag... I have tried it in a text Formula and an equation field.. However, I'm not sure how it will work for you since it's an image..

---

<div class="post-metadata">

**Author:** ![JulianSwal22288](https://avatars.discourse-cdn.com/v4/letter/j/8c91f0/32.png) [@JulianSwal22288](https://forums.knack.com/u/JulianSwal22288)\
**Post date:** [January 18, 2018, 2:20am UTC](https://forums.knack.com/t/how-do-i-pick-another-field-from-a-connection/7205/4 "2018-01-18T02:20:13Z")

</div>

I have almost the same question. I've created a drop down connected record with a text Formula in it so I can show the user the description and the value, but I want to pull that value into a field to use in a formula...

The drop down works with the connected record and ends up in the object record, but how do I access the value to use?