How to create a Single Select Column with PostgreSQL?

[mad99]

I would like to add in the Table "Employees" a column with "Position". Each Employe has only ONE position. This position should be dynamic and choosen to the table "Position" with "id" and "name" column.
So I would like to define a SingleSelect field in Employess table. In documentation for PostgreSQL is written I have to use Relationship.

Situation

In the Option-Popup from Relatiosn and can define the name of the column (Position) and chooose from drop-down select «Namy rows» in «Employees.

Problem

No matter whether I choose “to one row” or “to many row” in the second drop-down select field for the “Postition” table, it is always possible to select SEVERAL positions per employee instead of just ONE position as desired.
I would assume “To one row” in “Position” corresponds exactly to this wish and that only one position can be selected.
Unfortunately, this is not the case.

Questions

• What do I need to change?

• Or what do I understand wrong?

• Or is this a bug?

Would be great to get help or a tip on the correct documentation or a how-to or step-by-step example.

---

---

---

PS:

Outdated Documentations and Video

Unfortunately, the help page is outdated with many more options:
https://docs.budibase.com/docs/postgresql

And the video is also outdated:
https://www.youtube.com/watch?v=X6LgF15NqY0

[mad99]

Found the solution for my own - Hope will help others too!!! See attached Image: