I'm really new to setting relationships between tables.
I created 4 tables and they're in a one-on-one relationship, so I want to make these tables share the PK.
I'm using db browser for sqlite.
Thanks
Asked
Active
Viewed 56 times
0
-
What do you mean by "share the PK"? You will need to create a respective column in each of the tables and insert the same value in each of the tables for the corresponding rows – derpirscher Aug 08 '20 at 16:03
-
You might also look at [Foreign Keys](https://www.sqlite.org/foreignkeys.html) to help ensure consistency. – TripeHound Aug 08 '20 at 17:04