Hello everyone. Let's see if someone can help me. I created a new class called "Course". I created Many2Many relationship between "course" and "Partner". It works fine. I can add to a partner several courses. But I need to add a field to the form, so that when you would add a course to a partner, you ask an expiration date, to take partners_courses_rel Table 3 courses, the id of the partner, the id of the course, and the expiration date . Someone can tell me how to add the date field in the relationship? Thank you very much.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Akuntansi
- Inventaris
- PoS
- Project
- MRP
Pertanyaan ini telah diberikan tanda
2
Replies
16274
Tampilan
OpenERP Vietnam is correct. Relational tables for many2many fields are handled entirely by the ORM in the background, you cannot just add another column. Make a new object, link the two, and add a field for the expiration.
Ok. So as I have understood, now I have this:
Courses ----m2m----> Partners
and I think I have to do this:
Courses ----o2m----> Courses_partners ----m2o---->Partners
Is correct? Thank you very much for helping me because I'm so lost...!
Hi Rafael, it is correct.
Ok. I did as I have you told, but now I have a problem. I created the relationship between courses and courses_partners, and between courses_partners and partners, and I are the two date fields that I needed, but now when I get the drop down list to choose a course and choose one, then I will choose another, I reappears in the dropdown list the course he had chosen earlier. Would need to remove from the list the courses that I have selected. How could I?
Menikmati diskusi? Jangan hanya membaca, ikuti!
Buat akun sekarang untuk menikmati fitur eksklufi dan agar terlibat dengan komunitas kami!
Daftar| Post Terkait | Replies | Tampilan | Aktivitas | |
|---|---|---|---|---|
|
2
Des 25
|
3632 | ||
|
2
Des 25
|
217 | ||
|
3
Mei 25
|
3621 | ||
|
|
1
Apr 25
|
2540 | ||
|
one2one relational field
Diselesaikan
|
|
3
Sep 24
|
16421 |
Hi Rafael, instead of do that, you can create new object which have 2 field (contain object "cource" and "partner"), a field date, a field many2one into curent form (object contain your many2many field). Then you add a field one2many (reference new object) into current form.
Ok. I did as I have you told, but now I have a problem. I created the relationship between courses and courses_partners, and between courses_partners and partners, and I are the two date fields that I needed, but now when I get the drop down list to choose a course and choose one, then I will choose another, I reappears in the dropdown list the course he had chosen earlier. Would need to remove from the list the courses that I have selected. How could I?