# Links Between Databases

**URL:** https://community.glideapps.com/t/links-between-databases/72713
**Category:** Ask for Help
**Created:** [April 19, 2024, 2:56am UTC](https://community.glideapps.com/t/links-between-databases/72713 "2024-04-19T02:56:53Z")
**Posts on this page:** 1
**Showing post:** 4

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [April 22, 2024, 3:04am UTC](https://community.glideapps.com/t/links-between-databases/72713/4 "2024-04-22T03:04:02Z")

</div>

ah, I see.

So what you have there is essentially a Helper Table.

Okay, so here is what you can do.

- Start by add a RowIndex column (refer to the 2nd use case [here](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572))
- Next, add a Query column that targets your Students table, and apply whichever filters you need.
- Add a Lookup column that fetches the Student names via the Query column. This will give you an array of Student names.
- The final step is to transpose that array into a list. Add a Single Value column, target it at the Lookup column, and select X from start, where X is the RowIndex. That should give you a list of Student names, one per row.

---

_[View the full topic](https://community.glideapps.com/t/links-between-databases/72713)._