# External Database : Display value of Links not show

**URL:** <https://community.nocodb.com/t/external-database-display-value-of-links-not-show/1939>\
**Category:** Gallery-View\
**Created:** [June 17, 2025, 10:54am UTC](https://community.nocodb.com/t/external-database-display-value-of-links-not-show/1939 "2025-06-17T10:54:14Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![layeonchart](https://avatars.discourse-cdn.com/v4/letter/l/9fc29f/32.png) [@layeonchart](https://community.nocodb.com/u/layeonchart)\
**Post date:** [June 17, 2025, 10:54am UTC](https://community.nocodb.com/t/external-database-display-value-of-links-not-show/1939/1 "2025-06-17T10:54:15Z")

</div>

order\_custom is link to treatment table. I set display value of order\_custom is order\_id which is integer in PostgresDB. But when I open ticket of one random records in treatment table, it not show display value of link record of order\_custom. However, I inspect network and see get data APIs, the value of link record order custom is show along with other columns.

---

<div class="post-metadata">

**Author:** ![Navi](https://avatars.discourse-cdn.com/v4/letter/n/3be4f8/32.png) [@Navi](https://community.nocodb.com/u/Navi)\
**Post date:** [June 19, 2025, 11:25am UTC](https://community.nocodb.com/t/external-database-display-value-of-links-not-show/1939/2 "2025-06-19T11:25:57Z")

</div>

Can you provide the relation between `order_custom` and `treatment` table.

---

<div class="post-metadata">

**Author:** ![layeonchart](https://avatars.discourse-cdn.com/v4/letter/l/9fc29f/32.png) [@layeonchart](https://community.nocodb.com/u/layeonchart)\
**Post date:** [June 23, 2025, 3:07am UTC](https://community.nocodb.com/t/external-database-display-value-of-links-not-show/1939/3 "2025-06-23T03:07:54Z")

</div>

It should be 1-1 relationship, how can I define this in Postgres for NocoDB to understand. As I read the document about Display Value, the value display shouldn’t be the number from primary key, but other columns as text. How can I set display value as order\_id?

---

<div class="post-metadata">

**Author:** ![dstala](https://avatars.discourse-cdn.com/v4/letter/d/f04885/32.png) [@dstala](https://community.nocodb.com/u/dstala)\
**Post date:** [June 23, 2025, 4:33am UTC](https://community.nocodb.com/t/external-database-display-value-of-links-not-show/1939/4 "2025-06-23T04:33:49Z")

</div>

Find details here to update display value field

> **[Display value](https://nocodb.com/docs/product-docs/fields/display-value)**
>
> This article explains how to set display value for a table & its use.

---

<div class="post-metadata">

**Author:** ![layeonchart](https://avatars.discourse-cdn.com/v4/letter/l/9fc29f/32.png) [@layeonchart](https://community.nocodb.com/u/layeonchart)\
**Post date:** [June 23, 2025, 3:46pm UTC](https://community.nocodb.com/t/external-database-display-value-of-links-not-show/1939/5 "2025-06-23T15:46:38Z")

</div>

Ok. That’s what I thought too. So here is my work around method. First, I need to create a formula and choose order\_id column as value in that formula. Then I set display value to that formula column. Voila, we have a display value from link records as primary numeric key.