# ForeignKey is reverse LinkToAnotheRecord \[Aug 30\]

**URL:** <https://community.nocodb.com/t/foreignkey-is-reverse-linktoanotherecord-aug-30/654>\
**Category:** Discord-Discussions\
**Created:** [November 3, 2022, 10:40am UTC](https://community.nocodb.com/t/foreignkey-is-reverse-linktoanotherecord-aug-30/654 "2022-11-03T10:40:12Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 10:40am UTC](https://community.nocodb.com/t/foreignkey-is-reverse-linktoanotherecord-aug-30/654/1 "2022-11-03T10:40:12Z")

</div>

> 🙋‍♂️ **azriel46d** _asked_

## Hi all, first of all greaty work with Noco!

#### I was wondering has the Foreign Key ([https://docs.nocodb.com/setup-and-usages/column-types#foreignkey](https://docs.nocodb.com/setup-and-usages/column-types#foreignkey)) column type been deprecated as in my local instance i’m not seeing it.

#### 

#### Also is it possible when querying the API for the fields parameter to have something like `feature[0].name` which would return the nested field?

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 10:40am UTC](https://community.nocodb.com/t/foreignkey-is-reverse-linktoanotherecord-aug-30/654/2 "2022-11-03T10:40:13Z")

</div>

> 💁 **o1lab** _replied_

#### You can use LinkToAnotherRecord which is reverse of ForeignKey

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 10:40am UTC](https://community.nocodb.com/t/foreignkey-is-reverse-linktoanotherecord-aug-30/654/3 "2022-11-03T10:40:15Z")

</div>

> 💁 **o1lab** _replied_

#### nested querying is possible

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 10:40am UTC](https://community.nocodb.com/t/foreignkey-is-reverse-linktoanotherecord-aug-30/654/4 "2022-11-03T10:40:16Z")

</div>

> 💁 **o1lab** _replied_

#### see our docs

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 10:40am UTC](https://community.nocodb.com/t/foreignkey-is-reverse-linktoanotherecord-aug-30/654/5 "2022-11-03T10:40:17Z")

</div>

> 💁 **o1lab** _replied_

#### you can click on your project API docs itself, it will be easier

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 10:40am UTC](https://community.nocodb.com/t/foreignkey-is-reverse-linktoanotherecord-aug-30/654/6 "2022-11-03T10:40:18Z")

</div>

> 💁 **o1lab** _replied_

#### 😄

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 10:40am UTC](https://community.nocodb.com/t/foreignkey-is-reverse-linktoanotherecord-aug-30/654/7 "2022-11-03T10:40:19Z")

</div>

> 💁 **o1lab** _replied_

#### bottom left there is API docs and in top right menu there is swagger docs

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 10:40am UTC](https://community.nocodb.com/t/foreignkey-is-reverse-linktoanotherecord-aug-30/654/8 "2022-11-03T10:40:21Z")

</div>

> 🙋‍♂️ **azriel46d** _replied_

#### \<@310157751395287040\> I am using as described above the LinkToAnotherRecord. Due to the need of having multiple records poiniting towards I end up having to utilise the many to many approach. So over the API i get this

#### ```

#### {

#### “Id”: 4,

#### “value”: true,

#### “feature”: [

#### {

#### “Id”: 4,

#### “name”: “xxx.yyy.zzz”

#### }

#### ]

#### },

#### ```

#### I have tried to utilise in filtering to be able to get it to.

#### ```

#### {

#### “value”: true,

#### “feature”: “xxx.yyy.zzz”

#### }```

#### however utilising the docs and trying different strategies to try to obtain the first item in the array, does not make this happen. Is this the case? Or am i missing something ?

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 10:40am UTC](https://community.nocodb.com/t/foreignkey-is-reverse-linktoanotherecord-aug-30/654/9 "2022-11-03T10:40:22Z")

</div>

> 🙋‍♂️ **James2169** _replied_

#### Why has ForeignKey field type been removed?

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 10:40am UTC](https://community.nocodb.com/t/foreignkey-is-reverse-linktoanotherecord-aug-30/654/10 "2022-11-03T10:40:23Z")

</div>

[Autogenerated from discord](https://discord.com/channels/661905455894888490/1009111557311045652)

* * *

#### Join [NocoDB’s](http://www.nocodb.com/) community

[Discord](https://discord.gg/5RgZmkW) • [Twitter](https://twitter.com/nocodb) • [Reddit](https://www.reddit.com/r/NocoDB/) • [Docs](https://docs.nocodb.com/)