Any way to use more fields than Id and name from multiple link n:n relationship

[shalmaxb]

As the subject already tells, I am looking for a possibility to get more fields from a n:n relationship into the related entities.

I would like to work with some other fields, which is possible for n:1 relationships but not for n:n. I see in the database, there are only saved Id and the ID of the record`s name, but nothing usable for varchar fields.

Maybe I did not understand the reason for this, but it would be great to have this possibility. Does anybody have an idea?

[telecastg]

Hello shalmaxb

In many-to-many relationships, Espo creates a "middle table" that links the entities.



For example, if you want to pull the "role" field from the account_contact middle table, you would need to write a query like this:

Select account_contact.role
From account
Inner Join account_contact
On account_contact.account_id = account.id
Inner Join contact
On contact.id = account_contact.contact_id​

@eymen-elkum extension allows you to add and render middle table fields as tabular entries.
https://www.eblasoft.com.tr/espocrm-...le-inline-form

[shalmaxb]

I guessed something like that, though I never did it. I own the extension from Eymen, but in lack of a manual I never really fully understood that possibility. I will try to get it to work.

[esforim]

You may have missed this article in the product page: https://www.eblasoft.com.tr/post/lin...o-many-to-many

[shalmaxb]

Thank you, I have seen that but unfortunately it is very difficult to understand. The main subject I do understand: you will have to create the two related entities in the GUI without creating the relationship there. You will have to create the middle table by creating another entity, which will serve as the "connector" between the two. So far so good.
Then I should choose the field to connect. But where and which field from where? In the middle table? In one or both of the former created entities. When I look into the dropdown for the fields available to be connected, those are different in both of the entities and I could not figure out, what and where to choose. It`s hard, when you will have to guess and it is not clear, if I would really be able to use the extra fields for further utilization.

[esforim]

I don't have the Extensions so I can't experiment. I can only suggest to give it a try with the tutorial, then try with your own entity, then get some support from The Man himself.