# Search + Link to Other Table
**URL:** https://community.glideapps.com/t/search-link-to-other-table/22364
**Category:** Ask for Help
**Created:** [February 7, 2021, 10:40am UTC](https://community.glideapps.com/t/search-link-to-other-table/22364 "2021-02-07T10:40:28Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@qb15](https://community.glideapps.com/u/qb15)
#### Post date: [February 7, 2021, 10:40am UTC](https://community.glideapps.com/t/search-link-to-other-table/22364/1 "2021-02-07T10:40:29Z")
**Background:** I have two tables in a Question + Answer database:
- Questions: Where all the questions are
- Answers: Where the answers to the questions are
Answers can be used to answer many of the questions - so there is a one to many relationship from Answers to Questions.
**The Question:** How can I allow a user to search and select an answer for a question - to establish this link?
So that afterwards I will be able to:
1. See the ANSWERS tab an ‘inline list’ of all Questions the Answer is linked to.
2. in Questions Tab - display the answer attached to it via a LOOKUP field
I hope this is clear, please let me know if I haven’t clarified or explained anything well.
---
### Author:  [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [February 7, 2021, 1:20pm UTC](https://community.glideapps.com/t/search-link-to-other-table/22364/2 "2021-02-07T13:20:17Z")
May I ask how large is the database (how many questions)?
Have you considered combining the data into one table? Something like Question #’s in column A,
Questions in column B, Answers in column C?
---
### Author:  [@qb15](https://community.glideapps.com/u/qb15)
#### Post date: [February 9, 2021, 8:18am UTC](https://community.glideapps.com/t/search-link-to-other-table/22364/3 "2021-02-09T08:18:41Z")
Thanks @Eric_Penn.
I did, however that doesn’t work with the 1 to many relationship.
Many questions can have the same answer. So looking at it from an object perspective, they need to be separate tables.
Does that make sense? Am I missing something?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 9, 2021, 1:09pm UTC](https://community.glideapps.com/t/search-link-to-other-table/22364/4 "2021-02-09T13:09:00Z")
Can you share some screenshots of your data and what you are trying to do we can have a little more context? I guess it’s not quite clear to me what you are looking for. Sounds like you have a Relation from Answers to Questions…but do you also have a Relation from Questions to Answers?