# Connection - how to select which input field from the connection?

**URL:** <https://forums.knack.com/t/connection-how-to-select-which-input-field-from-the-connection/17286>\
**Category:** Ask the Community\
**Created:** [May 30, 2024, 9:15pm UTC](https://forums.knack.com/t/connection-how-to-select-which-input-field-from-the-connection/17286 "2024-05-30T21:15:33Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Meagan](https://avatars.discourse-cdn.com/v4/letter/m/839c29/32.png) [@Meagan](https://forums.knack.com/u/Meagan)\
**Post date:** [May 30, 2024, 9:15pm UTC](https://forums.knack.com/t/connection-how-to-select-which-input-field-from-the-connection/17286/1 "2024-05-30T21:15:33Z")

</div>

I have a table with several columns (“Calendar”). It contains address, employee, date, etc. When I am connecting this to another table (“Payments”). When I make the connection, it defaults to the first column of the connection. Is there a way to change this to specify which field/column I want it to pull from?

---

<div class="post-metadata">

**Author:** ![Les](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/les/32/4243_2.png) [@Les](https://forums.knack.com/u/Les)\
**Post date:** [May 30, 2024, 9:29pm UTC](https://forums.knack.com/t/connection-how-to-select-which-input-field-from-the-connection/17286/2 "2024-05-30T21:29:29Z")

</div>

Hi Meagan,

Thank you for sharing your question!

I could be wrong, but I believe what you’re looking for is the display field setting. You can learn about the display field here in this article: [Table Settings](https://learn.knack.com/article/table-settings)  
If you need to learn how to update the display field, here’s an article/guide for that: [How to Update Your Table’s Settings](https://learn.knack.com/article/how-to-update-your-tables-settings)

Please feel free to let me know that my assumption here is wrong. 🙂

And as always, please feel free to reach out to our support team with any how-to questions like this: [Create Support Ticket](https://learn.knack.com/article/kb-tickets/new)

---

<div class="post-metadata">

**Author:** ![Les](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/les/32/4243_2.png) [@Les](https://forums.knack.com/u/Les)\
**Post date:** [May 30, 2024, 11:23pm UTC](https://forums.knack.com/t/connection-how-to-select-which-input-field-from-the-connection/17286/3 "2024-05-30T23:23:02Z")

</div>

@Meagan

> [@Connected record selection view](https://forums.knack.com/t/connected-record-selection-view/12864/5):
>
> Hi @Les - thanks for the quick reply. That is not quite what I am looking for I don’t think. If I have a connection that has a lot of data, how do I select which data I want to be pulled for the connection?

^Responding to the above here 🙂

Since connection fields will use the parent table’s display field, if you want to get data from other fields in the parent table, you will need to use a text formula, regular formula (sum, min, max. etc.), equation, or possibly a conditional rule/task.

Maybe this article can be of assistance to you:  
[How to Show Multiple Fields in Your Connection Dropdown](https://learn.knack.com/article/f9o3u8gm7o-how-to-show-multiple-fields-in-your-connection-drop-down)

Also, @CarlHolmes 's reply in this thread may also be a solution you’re looking for: [Connected record selection view - #4 by CarlHolmes](https://forums.knack.com/t/connected-record-selection-view/12864/4)  
(Thanks Carl 🙂 )
