Double-hop foreign field

[josef]

Hello,

I have created a custom entity called CCase (this is not the default Case entity).
This entity has several one-to-one left relationships to other custom entities, for example CDemand and CSupply.

The “child” entities are not linked to each other, and I intentionally want to keep it that way.

Entity structure:


(Each child is linked only to CCase, not to each other.)

What I would like to achieve is the following:

In the detail view of CSupply, I want to display some fields from CDemand (which is linked to the same CCase).

Is this possible in EspoCRM?
For example, can this be done using something like a foreign field, but with a double-hop relationship (CSupply → CCase → CDemand)?

[dreginald]

Since there is no relationship between CSupply and CDemand, it is not feasible to get the values of fields in CDemand in CSupply using foreign fields. You can create new fields in CCase to fetch the value to CCase from CDemand (you can write formula for the same) and create foreign field between CCase and CSupply

[josef]

Thank you for your response.

Unfortunately, copying the data to CCase is not an option in my case. The values must remain fully synchronized, and I want to avoid duplicating data.

Is there any other way to achieve this?
For example, is there an extension in EspoCRM that would allow accessing fields from CDemand in CSupply without introducing data duplication?

Thanks again for your help.