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

Discord-Discussions
1

:man_raising_hand: BoMBx asked

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

2

:man_raising_hand: wkw replied

internally or externally?

3

:man_raising_hand: wkw replied

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

4

:man_raising_hand: 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

:man_raising_hand: BoMBx replied

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

6

:man_raising_hand: BoMBx replied

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

7

:man_raising_hand: wkw replied

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

8

:man_raising_hand: BoMBx replied

I think I misunderstand about your LinkToAnotherRecord

9

:man_raising_hand: wkw replied

if FKs are present, then LinkToAnotherRecord will be created automatically

10

:man_raising_hand: BoMBx replied

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

11

:man_raising_hand: BoMBx replied

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

12

:man_raising_hand: BoMBx replied

let me show you

13

:man_raising_hand: BoMBx replied

image0
image0332×186 7.35 KB

14

:man_raising_hand: BoMBx replied

it was set here

15

:man_raising_hand: BoMBx replied

image0

16

:man_raising_hand: BoMBx replied

here is the nocodb

17

:man_raising_hand: BoMBx replied

seems nothing change

18

:man_raising_hand: BoMBx replied

image0
image0285×483 6.42 KB

19

:man_raising_hand: wkw replied

do they exist before the project creation?

20

:man_raising_hand: BoMBx replied

nope