Hi,
is it possible, using ADK, to add a field that is specific to a many-to-many relationship ?
For example, lets say I have a Contract and multiple contractors (partners). I’d like to have many-to-many relationship between Contract and Partner, and to be able to flag a particular relation with a type (for example, “Main contractor”, “Subcontractor”, etc…)
Is this possible ?
Ok, replying to myself : I managed to do this by creating an explicit relationship table, and using o2m et m2o fields types.
contract – o2m --> relationship <-- m2o – partner
in relationship, I can manage the information I want (type of contractor, date, etc…).
My remaining problem is : how can I display more than the partner’s namecolumn in my contract form ??
yes, you need to create a new object for that purpose.
You can display partner fields in your contract form using dotted field :
<field name="partner.foo">
<field name="partner.bar">
where foo and bar are fields of Partner.
what if I have another domain named Project now in project I will select Partner and based on the selection partner’s field it’s contracts will be listed how can I achieve it?