Microsoft Dynamics 365 | Integration, Dataverse...

Help with Dataverse relationships

(0) Share

Report

Posted on by Learner23

I am using OOB tables (contact and Account) and a custom (Application) table for one of my requirement. The requirement is to submit application from portal and later validated in D365. 1 account can submit many applications (1:N - Account:Application), Many contacts can be part of an account (N:1 - Contact: Account) and a contact can submit many applications (1:N - Contact:Application)

How to create relationships between these tables. I want to generate an application number once the form is submitted in the portal. The application should list all the details including account and the contacts.. How to achieve this.. ?

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Bipin D365 28,983 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

Create new custom entity and create below fields in custom entity

Account lookup

Contact lookup

Application (custom entity) Lookup

Was this reply helpful? Yes No
Suggested answer

Haig Liu Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Learner23,

We can place a custom form on the portal, and setting filters for the custom lookup fields can further reduce the number of results displayed.

We can also use list to display records from custom tables:

Was this reply helpful? Yes No