# Reference Column that Includes All Rows From Parent?

**URL:** <https://connect.superhuman.com/t/reference-column-that-includes-all-rows-from-parent/44309>\
**Category:** Ask the Community\
**Created:** [November 9, 2023, 11:58pm UTC](https://connect.superhuman.com/t/reference-column-that-includes-all-rows-from-parent/44309 "2023-11-09T23:58:07Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![thefifth\_reddit](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/thefifth_reddit/32/38737_2.png) [@thefifth\_reddit](https://connect.superhuman.com/u/thefifth_reddit)\
**Post date:** [November 9, 2023, 11:58pm UTC](https://connect.superhuman.com/t/reference-column-that-includes-all-rows-from-parent/44309/1 "2023-11-09T23:58:07Z")

</div>

Say a table contains one column and three rows, respectively containing the strings ‘Cat,’ ‘Dog,’ and ‘Bird.’

If I create a blank table and set a column in the new table to reference the pet type table, then I can choose from a select list showing only those three values when manually clicking rows in the reference column.

I’d like a way to have the new table (with a reference column being added) automatically include a row for every pet type in the parent table.

Can it be done?

Edit: here’s a sample doc showing what I’m trying to do: [https://coda.io/d/Relation-Column-Test\_dwKJUKmHndi/Relation-Column-Test\_suC7R#\_lus4K](https://coda.io/d/Relation-Column-Test_dwKJUKmHndi/Relation-Column-Test_suC7R#_lus4K)

---

<div class="post-metadata">

**Author:** ![Piet\_Strydom](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/piet_strydom/32/19269_2.png) [@Piet\_Strydom](https://connect.superhuman.com/u/Piet_Strydom)\
**Post date:** [November 10, 2023, 3:40am UTC](https://connect.superhuman.com/t/reference-column-that-includes-all-rows-from-parent/44309/2 "2023-11-10T03:40:23Z")

</div>

Trying to understand your request: so the two tables will have the same number of rows?

---

<div class="post-metadata">

**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\
**Post date:** [February 8, 2024, 3:40am UTC](https://connect.superhuman.com/t/reference-column-that-includes-all-rows-from-parent/44309/3 "2024-02-08T03:40:30Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.