# Display a Table that shows records connected to an object 3 layers deep

**URL:** <https://forums.knack.com/t/display-a-table-that-shows-records-connected-to-an-object-3-layers-deep/6843>\
**Category:** Get Answers\
**Created:** [February 1, 2019, 7:22pm UTC](https://forums.knack.com/t/display-a-table-that-shows-records-connected-to-an-object-3-layers-deep/6843 "2019-02-01T19:22:19Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![TreyPeirce56514](https://avatars.discourse-cdn.com/v4/letter/t/22d042/32.png) [@TreyPeirce56514](https://forums.knack.com/u/TreyPeirce56514)\
**Post date:** [February 1, 2019, 7:22pm UTC](https://forums.knack.com/t/display-a-table-that-shows-records-connected-to-an-object-3-layers-deep/6843/1 "2019-02-01T19:22:19Z")

</div>

We have the current object structure set up:

Sales Reps(user)

Jobs

Rooms

Door Types

Currently Sales reps are connected to a Job (1\>Many)

Jobs are connected to a Room (1\>Many)

and Rooms are connected to Door Types (1\>Many)

So for example we will have a Job with an assigned sales person that will have many rooms, each room will have one door type.

I would like to create a table on the "Job" Details page that shows the Connected door types and lists the rooms that each door type is present in. Ex. the Madison (door type) and then a rooms column that lists: kitchen, bathroom 1, etc.

I have no issue creating these lists when the connection is just one deep. However, when I attempt to do this in this situation, I have no access to the Door Types data source on the Job details page when I create a table.

Does anyone have any insight on this?

Thanks in advance,

Eddie San Juan

---

<div class="post-metadata">

**Author:** ![Rachel1](https://avatars.discourse-cdn.com/v4/letter/r/e0b2c6/32.png) [@Rachel1](https://forums.knack.com/u/Rachel1)\
**Post date:** [January 4, 2022, 11:58pm UTC](https://forums.knack.com/t/display-a-table-that-shows-records-connected-to-an-object-3-layers-deep/6843/2 "2022-01-04T23:58:21Z")

</div>

Hey Eddie,

Did you ever work out how to do this? Drives me crazy. Thanks
