Lookup any value from related table

[Caddy2]

Hello,

I need several dataverse tables, where one table should look up values from another tables. There is an m:n connection between the tables.

Is there a way to do this without code?
If I understand it correctly lookup columns show only the primary column of the other table and business rules are not possible and there is no parent-child relationship where calculated fields could be used right?

Would be great if someone could help me with this!

Greetings

[rampprakash]

Hi @Caddy2 

Am afraid it is not possible,

Consider if we have Account and Opportunity Table

Opportunity contains Account Lookup which is From account it is 1:N Relationship but we cannot use the Opportunity lookup, if we are using Lookup it will be 1:N from account level,

But you can use Subgrid to show the values

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA

Blog : https://microsoftcrmtechie.blogspot.com

[Caddy2]

Thanks for your quick answer @rampprakash!

So to get the values in the process of creating a new entry, I have to use a plug-in right?

[rampprakash]

Yes thats the best way i can say else use Microsoft flow.

[dpoggemann]

Hi @Caddy2 ,

Usually to accomplish what you are trying to do here I utilize custom "Intersect" or "Join" tables where I have the following type of model:

               1      N                       N       1

Table A  ------->  Intersect C  <------  Table B

This allows me to then have two lookups on the Intersect table with Table A and Table B.  You can utilize real-time workflows to set values on this intersect table from the related lookup tables (A & B).  Note, Business Rules apply to same table, not related tables.

Is this what you are looking to do?