I sometimes find it a bit tedious to create our relationship and choose the type of relationship. With some tools, it’s really simple and practical.
Different types :
One to many
one to one
many to many
For example, in fibery, when you create a relationship, you choose the type of relationship you want, which I find simpler. It’s less cumbersome to go wandering around the different tables to change the allow select.