F
Filament3w ago
Toni

ManyToMany Relationship via Select element

Why do I have to set a Select-Element to ->multiple() in case of belongsToMany? The use case why I am asking is, that I have a manyToMany relationship between users and institutes. - In case a user has a system role, no relationship is needed - In case a user has a monocentric role, the relationship is oneToMany (seen from a institute perspective) - In case a user has a multicentric role, the relationship turns into manyToMany. I would like to solve this with a Select-Element and make it multiple or not, depending on the role. But if multiple is false, I got an error message:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'institutes' in 'field list' (Connection: mysql, SQL: update `users` set `institutes` = 2, `users`.`updated_at` = 2024-06-09 15:39:09 where `id` = 1)
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'institutes' in 'field list' (Connection: mysql, SQL: update `users` set `institutes` = 2, `users`.`updated_at` = 2024-06-09 15:39:09 where `id` = 1)
If I turn the select element to multiple choice everything works fine, except of monocentric roles (I can attach more than one institute). What is the reason for this "limitation"?
0 Replies
No replies yetBe the first to reply to this messageJoin