Skip to Content
This question has been flagged
many2manyStudiov14
1 Reply
2471 Views
Avatar
Yeison X

Hi.

I would really appreciate if someone could give me a guide. 

I have 2 models:

  • Doctors

  • Patients

In the view where I create the patients, I add a Many2Many field with the Doctors model.

The main idea is to link a patient with as many doctors as I want.

Then, add in the Sale Order view  the following Many2one fields:


- Patient

- Doctors


What would you like?

Doctor field should only show those doctors that are already linked to the patient.


What happens right now?

The Doctor field shows all the doctors that are created. 


Thank you!

Avatar
Discard
Avatar
Sudhir Arya (ERP Harbor Consulting Services)
Best Answer

For this, you will have to write an onchange method to set the domain to filter the doctors based on the selected patient.

You can write the following type of onchange:

@api.onchange('patient_id')
def onchange_patient(self):
 return {'domain': {'doctor_ids': [('id', 'in', self.patient_id.doctor_ids.ids)]}}
Avatar
Discard
Related Posts Replies Views Activity
How to get Many2many records ids Solved
many2many v14
Avatar
Avatar
1
Jun 22
3864
Adding a column in Replenishment
Studio v14 replenishment
Avatar
2
Nov 23
749
How to make employee_ids with value of Employee - Department. Solved
tags many2many v14
Avatar
Avatar
1
Sep 23
740
Archiving an opportunity mark it as "Lost" which is not correct.
bug Studio v14
Avatar
Avatar
1
Mar 22
1646
Field for subtotal and total in odoo studio?
purchase_order Studio v14
Avatar
Avatar
1
Feb 22
4187