# Lookup Table Question
**URL:** https://community.nocodb.com/t/lookup-table-question/754
**Category:** Uncategorized
**Created:** [February 21, 2023, 2:26am UTC](https://community.nocodb.com/t/lookup-table-question/754 "2023-02-21T02:26:47Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@jst](https://community.nocodb.com/u/jst)
#### Post date: [February 21, 2023, 2:26am UTC](https://community.nocodb.com/t/lookup-table-question/754/1 "2023-02-21T02:26:47Z")
I have two tables. The second table contains labels for a field in the first table. Here is how it looks like.
```auto
Table A
Key1
...
Field1
...
Table B
Key1
LanguageKey
Label
```
So, a proper lookup in Table B would be: “Key1”,“EN” to get the Label field in English language.
Can this be done with the lookup feature of Nocodb?
I am new and so I would appreciate step-by-step instructions if possible. Thank you!
---
### Author:  [@kylee\_nocodb](https://community.nocodb.com/u/kylee_nocodb)
#### Post date: [February 24, 2023, 11:02pm UTC](https://community.nocodb.com/t/lookup-table-question/754/2 "2023-02-24T23:02:19Z")
For step by step directions:
1. Add new column : Click on ‘+’ icon to the left of column headers
2. Feed column name
3. Select column type as ‘Lookup’
4. Choose child table
5. Select child column
6. Click on ‘Save’
You can learn more here: [Lookup - NocoDB](https://docs.nocodb.com/setup-and-usages/lookup/)
Let us know if this helped.
---
### Author:  [@jst](https://community.nocodb.com/u/jst)
#### Post date: [February 25, 2023, 3:28am UTC](https://community.nocodb.com/t/lookup-table-question/754/3 "2023-02-25T03:28:23Z")
Thank you for your reply!
I have tried to follow your instructions, but there is no child table available in step 4.
So, I went to the other table and added a column with ColumnType=“LinkToAnotherRecord”. Then I went back to the first table the other table showed up as a child table.
However, it doesn’t auto populate the new column and I have to manually match up the entire table row by row.
What am I missing?
---
### Author:  [@kylee\_nocodb](https://community.nocodb.com/u/kylee_nocodb)
#### Post date: [February 27, 2023, 5:11pm UTC](https://community.nocodb.com/t/lookup-table-question/754/4 "2023-02-27T17:11:58Z")
Is the LinkToAnotherRecord column referencing the correct data?
Need more clarity on your example, do you mean a lookup in Table B would be “Key1”,“EN” to get the Field1 field in Table A?
LinkToAnotherRecord does not auto-populate because it has no way of knowing which records to link to, however you can populate multiple rows at a time using the API.
---
### Author:  [@jst](https://community.nocodb.com/u/jst)
#### Post date: [February 28, 2023, 8:33pm UTC](https://community.nocodb.com/t/lookup-table-question/754/5 "2023-02-28T20:33:07Z")
How do I specify what the LinkToAnotherRecord column is referencing?
Your example lookup (using “Key1”,“EN”) would be ideal, but I can get by without the language for now.
So, the lookup is not pulling the desired field for the entire table. I can currently click a record in the first table to get a one corresponding record from the second table, but I was wondering how I can generate a complete result table. Not possible without API coding?
---
### Author:  [@kylee\_nocodb](https://community.nocodb.com/u/kylee_nocodb)
#### Post date: [February 28, 2023, 11:17pm UTC](https://community.nocodb.com/t/lookup-table-question/754/6 "2023-02-28T23:17:58Z")
Correct, its not possible to auto-populate LinkToAnotherRecord, you can only populate multiple at a time via. API.