# Display only one record in connected records (Table view)

**URL:** <https://forums.knack.com/t/display-only-one-record-in-connected-records-table-view/12544>\
**Category:** Ask the Community\
**Created:** [May 16, 2022, 7:12pm UTC](https://forums.knack.com/t/display-only-one-record-in-connected-records-table-view/12544 "2022-05-16T19:12:43Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nino](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/nino/32/2032_2.png) [@Nino](https://forums.knack.com/u/Nino)\
**Post date:** [May 16, 2022, 7:12pm UTC](https://forums.knack.com/t/display-only-one-record-in-connected-records-table-view/12544/1 "2022-05-16T19:12:43Z")

</div>

Anyone know if it is possible to only display a single record for connected records in table view? I see option to separate the records displayed by comma or line break. I just only want to list the most recent record. Thanks!

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/a/a0a3932cd2092e8f9189e3d7a5cb349a7f753ce0.png)

---

<div class="post-metadata">

**Author:** ![JD\_Zappfy](https://avatars.discourse-cdn.com/v4/letter/j/d9b06d/32.png) [@JD\_Zappfy](https://forums.knack.com/u/JD_Zappfy)\
**Post date:** [May 17, 2022, 5:25pm UTC](https://forums.knack.com/t/display-only-one-record-in-connected-records-table-view/12544/2 "2022-05-17T17:25:21Z")

</div>

> [@Nino](#):
>
> Anyone know if it is possible to only display a single record for connected records in table view? I see option to separate the records displayed by comma or line break. I just only want to list the most recent record. Thanks!

Hi Nino,

There’s likely a few options here, including a Knack workaround where you update a newly added one-to-one connection field in your source topic every time an update is triggered from the child records (from the other one-to-many connection field you’re currently using), but honestly the easiest option for you, if you’re just trying to solve this problem for a single column display, is to use custom CSS to target that column and hide all but the first/last line (depending on your sort order).

The following code is an example:

```auto
/* Hide the values -- must not be using links */
/* Change the view_x and field_x to your respective view number and field number (should be the connection field) */
/* Use :last-child instead of :first-child if you want to hide all but the last line */

#view_x tbody td.field_x span span:not(:first-child) {
    display: none;
}

/* Hide the line breaks */

#view_x tbody td.field_x span br {
    display: none;
}

```

Hope that helps!