For our clients(students) we need to know about their linguistic competence.
It means that we must register which languages they know and which level they have for each language.
In the table below you can see how this can be registered, as an example:
Known languages for STUDENT_01 | Known languages for STUDENT_02 |
+ English: + Understand + Talk + Reads + Spanish + Maternal + French + Understand + Reads | + Punjabi: + Maternal + English + Maternal + French + Understand + Talk |
We've an x_students model already implemented (which is already in use).
As an initial approach we tried to define an x_languages model in order be used for the many2many field (x_known_languages) on x_students model.
=> It's okay to (multi)select which languages know each student
/!\ But we don't know how to add/relate these levels to each known language (for each student).
I've tried to do it with creating another model (x_languages.levels) to be used by a new many2many field into the x_languages model... but doing it the "levels" are added for the entire "language", so I think this is not the way...
Does anybody have an idea about how it can or should be implemented?
I've tried to look up here and also in google about it but i hadn't luck.
Thanks all and best regards,
*We're using Odoo 13.0 (Community Edition).