I have a field called 'Customer' in the CRM module that links to records in the Contacts module. Additionally, I have another field called 'Site' that links to records in the Site module.
In the Contacts module there is a manyToMany field that connects to the site module.
Currently, all fields are working fine. However, I want to enhance the 'Site' field in the CRM so that it only displays sites related to the selected 'Customer'.
I'm using Odoo Studio (web version) for this customization. Could anyone provide detailed steps or a solution on how to achieve this filtering?