# Gather content from first column of several tables

**URL:** https://community.baserow.io/t/gather-content-from-first-column-of-several-tables/5092
**Category:** Baserow Help
**Tags:** automation, help-wanted, formula
**Created:** [April 23, 2024, 11:06am UTC](https://community.baserow.io/t/gather-content-from-first-column-of-several-tables/5092 "2024-04-23T11:06:41Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![rensinghoff](https://community.baserow.io/user_avatar/community.baserow.io/rensinghoff/32/2036_2.png) [@rensinghoff](https://community.baserow.io/u/rensinghoff)
#### Post date: [April 23, 2024, 11:06am UTC](https://community.baserow.io/t/gather-content-from-first-column-of-several-tables/5092/1 "2024-04-23T11:06:41Z")

</div>

Hey there!

I’m searching for a solution to gather the content from the first column of several tables in one overview table.

i.e.:  
Table 1: small objects; first column: ID of small objects (this column is a formular)  
Table 2: medium objects; first column: ID of medium objects (this column is a formular)  
Table 3: big objects; first column: ID of big objects (this column is a formular)  
Table 4: here would be an overview with all object IDs of table 1-3. These should include all existing IDs and update as new rows/objects will be added in tab 1-3.

Thank you!  
Best regards  
Berenike

---

<div class="post-metadata">

### Author: ![olgatrykush](https://community.baserow.io/user_avatar/community.baserow.io/olgatrykush/32/219_2.png) [@olgatrykush](https://community.baserow.io/u/olgatrykush)
#### Post date: [April 23, 2024, 3:44pm UTC](https://community.baserow.io/t/gather-content-from-first-column-of-several-tables/5092/2 "2024-04-23T15:44:54Z")

</div>

Hey @rensinghoff, you can use a lookup field type to connect rows from different tables in one table. Here’s how it works: [Lookup field // Baserow](https://baserow.io/user-docs/lookup-field). 🙂
