# Change field on connected record

**URL:** <https://forums.knack.com/t/change-field-on-connected-record/13723>\
**Category:** Get Answers\
**Created:** [February 1, 2023, 4:30pm UTC](https://forums.knack.com/t/change-field-on-connected-record/13723 "2023-02-01T16:30:58Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Joshua](https://avatars.discourse-cdn.com/v4/letter/j/48db29/32.png) [@Joshua](https://forums.knack.com/u/Joshua)\
**Post date:** [February 1, 2023, 4:30pm UTC](https://forums.knack.com/t/change-field-on-connected-record/13723/1 "2023-02-01T16:30:58Z")

</div>

I have a table called Projects with these fields:  
Project Name  
Client Name  
Project Number  
I have a text formula called Full Name which is Project Number + Client Name + Project Name

I have another table called Inventory that is connected to Projects. When I am creating a new item in Inventory, the dropdown for the connected record shows the Project Name. I want it to show the Full Name.  
Any ideas how I can do this?

---

<div class="post-metadata">

**Author:** ![Wolfgang\_Brötz](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/wolfgang_br%C3%B6tz/32/1465_2.png) [@Wolfgang\_Brötz](https://forums.knack.com/u/Wolfgang_Br%C3%B6tz)\
**Post date:** [February 1, 2023, 4:50pm UTC](https://forums.knack.com/t/change-field-on-connected-record/13723/2 "2023-02-01T16:50:17Z")

</div>

Hi Joshua, can you change in the “Records” section in the “Object settings” the display field from “Project Name” to “Full Name”?

---

<div class="post-metadata">

**Author:** ![Joshua](https://avatars.discourse-cdn.com/v4/letter/j/48db29/32.png) [@Joshua](https://forums.knack.com/u/Joshua)\
**Post date:** [February 1, 2023, 6:37pm UTC](https://forums.knack.com/t/change-field-on-connected-record/13723/3 "2023-02-01T18:37:29Z")

</div>

That worked!  
For anyone else looking for this:  
Go to Records, then click the down arrow next to your table, then click Settings.  
Set Display Field to the field you want to show.  
Click Save.
