LinkToAnotherRecord direction doubt [Mar 04]

Discord-Discussions
1

:raising_hand_man: Richnou asked

Hello

In the “Link To Another Record” page https://docs.nocodb.com/setup-and-usages/link-to-another-record you said:

- ‘Has Many’: corresponds to the ‘One-to-many’ relationships

- ‘Many To Many’: corresponds to the ‘Many-to-many’ relationships

For M-M, no problème, but for 1-N it doesn’t work ; it’s like a 1-1…

If I take an “publisher” already selected, it is de-selected from the old one…

(see video https://r-c.es/nocodb-hasmany.mp4 )

What’s it’s wrong in my structure ?

2

:person_tipping_hand: o1lab replied

Its the other way around

Publishers has many books

3

:person_tipping_hand: o1lab replied

so you have to create that relation from publishers table to books

4

:raising_hand_man: Richnou replied

Ouch… Ok…

5

:raising_hand_man: Richnou replied

I have a little too much of a reflex to create the foreign key in the book table

6

:raising_hand_man: Richnou replied

Many (to many) thanks :wink:

7

:person_tipping_hand: o1lab replied

we’d the option of foreign key and we took it down :slightly_smiling_face:

8

:raising_hand_man: Richnou replied

Once we know… :grin:

9

:raising_hand_man: Richnou replied

I will add an addendum to my video :wink:

10

Autogenerated from discord

Join NocoDB’s community

Discord • Twitter • Reddit • Docs