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
- 会計
- 在庫
- PoS
- Project
- MRP
この質問にフラグが付けられました
2
返信
15852
ビュー
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?
| 関連投稿 | 返信 | ビュー | 活動 | |
|---|---|---|---|---|
|
3
5月 25
|
1850 | ||
|
|
1
4月 25
|
1382 | ||
|
3
9月 24
|
14341 | ||
|
2
2月 24
|
2571 | ||
|
1
7月 23
|
2795 |
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?