Forums

Retrieve and display data from parent/child entities on single page Cancel The title field is required!

1. Mike Cohen

   

   31 posts
   Registered:
   10 Aug 2021
   21 Sep 2021

   Link to this post

   We are trying to field applications via a crm portal.  We have an "application" entity that is N:1 with the contact entity (each contact can have multiple applications).  
   
   The applications are filled out gradually throughout the year and users will return and fill out different parts of the application at different times. 
   
   I'm unsure how to display an editbale copy of a contact's particular application each time they login to the portal.  What is the recommended method when a contact logs into a portal to retrieve and display their most recent application record in CRM and present it to the user to be edited? 
   
   
   
   
2. Brady Ward

   

   92 posts
   Registered:
   19 Aug 2021
   23 Sep 2021 in reply to Mike Cohen

   Link to this post

   Hi Mike,
   
   Is Application a field on the contact entity or do contacts become a field on the Application entity (ie. Owner/Contact Owner)?
   
   Also, there are a few potential options for solving your problem.
   
   Option 1 (easiest) - Using a grid/list view to filter your data and return only one record after sorting by date (this would allow a user to then select the edit option on the record and begin editing the application).
   Option 2 - Nesting 2 forms together and building the relationship between them. This would also require the above filtering for the FetchXML (https://www.crmportalconnector.com/developer-network/documentation/how-tos/mvc-based-widgets/how-to-configure-multiple-entities-on-form)
   
   Looking forward to your reply,
   Brady
   
3. Mike Cohen

   

   31 posts
   Registered:
   10 Aug 2021
   Answered

   10 Dec 2021

   Link to this post

   Listview option worked.  Thanks