Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

RaulMolina's avatar

Select relationship tablas anidadas

I have the user table with id, name, email, password. I have the teacher table with id User_id. I have the department table with id, name, description and departmenthead_id. I have a 1 to 1 relationship between the user table and the teacher table. I have a 1 to 1 relationship between the department table (departmenthead) and the teacher table. In the department resource in the form section, I have a select with a relationship with the department teacher relationship. I want the select drop-down list to show the name of the teacher who is in the user table, and it only lets me see the user_id. How can I do it?

0 likes
1 reply
vincent15000's avatar

You should write your post in English, otherwise you will have very few answers.

Please or to participate in this conversation.