Create nested subgrid for a n:n relationship

(0) Share

Report

Posted on by Community Member

Hi,

I've created some custom entities (A & B for exemple) with N:N relationship between them to bypass some limitation I encountered in the Product Entity.

I created a subgrid view of A in my quote form and I want to show a nested subgrid of B in this subgrid view. I have an issue to define the parentID of the nested subgrid because I have no lookup between my two entities.

So I wondering if I can create a lookup between A & B without loosing the N:N relationship or if there is another way to create a link between my entities ?

Thank you for your support,

Best Regards,

Alexandre

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Wahaj Rashid 11,321 on at

Like (0)

Report
Hi,

Thank you for your query.

There are two ways of creating N:N Relationships:

Implicit: Use the N:N relationship tab in one of the entities customization (which you did). This will create a resolving entity, however you won't have direct access to it.

Explicit: Create a custom entity which will have two N:1 relations (lookups), one for Entity A and other for Entity B.

The second approach is used when you want a form for your resolving entity or if you need to capture additional information when associating the two records.

In your scenario, second approach should work.

To summarize, create an entity called A_B (example), add a lookup to A and another to B. Fill the name field (primary field) using a Business rule (so the users do not have to fill it manually). Then create your nested subgrids using the Lookups on this new entity.

Let me know if you need further clarification.

Best,

Wahaj

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Wahaj,

Thank you for your response.

I tried to follow your explaination and I'm stuck at the nested subgrid creation.

I've create A, B and A_B entities. then I've create lookups N:1 to A and B (picture below)

Then I added A and B lookups in the A_B form

But after that I don't understand what I have to do. I've try to create a nested grid in Entity A, B and A_B and I can't because I still didn't have the parentID for the nestedgrid.

And I have the same problem whan I link another entity.

I'm sure that I made a mistake but I don't see where.

Thanks for your help.

Best,

Alexandre

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Hi Wahaj,

I was lost yesterday but I'm better now :-) So, I understand correctly your solution and it's seems that it's working to resolve my issue.

Thank you very much for your time and explanation.

I'll keep you posted when everything will work.

Thank you again.

Best,

Alexandre

Was this reply helpful? Yes No
Suggested answer

LuHao 40,892 on at

Like (0)

Report

Hi Alexandre,

The nested subgrid is only available to the 1:N relationship in the 1:N sub-grid, but is not available to the N:N sub-grid, which is by design.

For example, there are three entities, Grandparent, Parent, and Children. The relationship between them is 1:N and 1:N, so we can add a Parent sub-grid on the Grandparent form, and configure the nested subgrid to display the Children of each Parent.

Therefore, it is impossible to achieve your needs through nested subgrid.

What I can think of is to add a button to the N:N relationship sub-grid. This button will appear when only one record is selected. The click event is to display related records of the selected record in a web resource on the form.

In short, there is no coding-free solution.

Was this reply helpful? Yes No
urklnme 439 on at

Like (0)

Report

please post the full details of what you did to make this work. :)

Was this reply helpful? Yes No