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.. ?