Refresh table's relationship on nocodb after updating and creating foreign keys on table [Apr 27]

Discord-Discussions
1

:raising_hand_man: BoMBx asked

hi, is it possible to refresh table’s relationship on nocodb after updating and creating foreign keys on table?

2

:raising_hand_man: wkw replied

internally or externally?

3

:raising_hand_man: wkw replied

n wt does it mean by “refresh table’s relationship on nocodb”

4

:raising_hand_man: BoMBx replied

I mean I need data of joining table but at initial project on nocodb I didn’t create foreign keys yet then I cannot fetch data of joining between two or multiple tables

5

:raising_hand_man: BoMBx replied

I just did it with external program but it is same database that nocodb connect to

6

:raising_hand_man: BoMBx replied

If got other way to set foreign keys via nocodb directly would be great.

7

:raising_hand_man: wkw replied

it’s like LinkToAnotherRecord but with real relation in db?

8

:raising_hand_man: BoMBx replied

I think I misunderstand about your LinkToAnotherRecord

9

:raising_hand_man: wkw replied

if FKs are present, then LinkToAnotherRecord will be created automatically

10

:raising_hand_man: BoMBx replied

what i mean is … can it automatically join tables after creating foreign keys as initial project?

11

:raising_hand_man: BoMBx replied

really? I don’t know why my table it not automatically show up

12

:raising_hand_man: BoMBx replied

let me show you

13

:raising_hand_man: BoMBx replied

image0

14

:raising_hand_man: BoMBx replied

it was set here

15

:raising_hand_man: BoMBx replied

image0
image01165×86 8.24 KB

16

:raising_hand_man: BoMBx replied

here is the nocodb

17

:raising_hand_man: BoMBx replied

seems nothing change

18

:raising_hand_man: BoMBx replied

image0

19

:raising_hand_man: wkw replied

do they exist before the project creation?

20

:raising_hand_man: BoMBx replied

nope