{"id":33855,"date":"2023-01-25T14:35:40","date_gmt":"2023-01-25T09:05:40","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=33855"},"modified":"2023-01-25T14:35:40","modified_gmt":"2023-01-25T09:05:40","slug":"add-or-edit-table-relationships-using-the-model-driven-application-form-designer","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2023\/01\/add-or-edit-table-relationships-using-the-model-driven-application-form-designer\/","title":{"rendered":"Add or Edit table relationships using the Model-Driven Application form designer"},"content":{"rendered":"<p>As we know, usually, we needed to create a relationship of tables to make proper data management and show data in the application. So, generally before designing the model-driven application forms, we had to be sure the tables, columns, and the relationship between them was fine. But now, we need not worry about creating relationships of tables before the form design has been done as within the form designer itself, we can create relationships of the table. This saves a lot of time for the developer if the developer forgets to create a relationship and he\/she begins the form creation. With this update, the developer doesn\u2019t need to go back to the table section and select the relationship option as seen in the screenshot below-<\/p>\n<p><img decoding=\"async\" class=\"alignnone wp-image-33856\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/1model-driven-application.jpeg\" alt=\"model-driven application\" width=\"726\" height=\"485\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/1model-driven-application.jpeg 644w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/1model-driven-application-300x200.jpeg 300w\" sizes=\"(max-width: 726px) 100vw, 726px\" \/><\/p>\n<p>Instead of navigating to the above screen, the developer can simply create a relationship with the form designer itself.<\/p>\n<p>Let\u2019s see how it is done-<\/p>\n<p>Open any table Main Form, here <strong>\u201cAccount\u201d<\/strong> main form and select the <strong>Related<\/strong> tab, upon clicking on the <strong>Related<\/strong> menu (i.e. marked as A) you will find the + icon, select the <strong>+<\/strong> <strong>icon<\/strong> (i.e. marked as B)\u00a0 for adding the relationship as shown below:<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-33860\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/2model-driven-application.jpeg\" alt=\"model-driven application\" width=\"965\" height=\"600\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/2model-driven-application.jpeg 965w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/2model-driven-application-300x187.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/2model-driven-application-768x478.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/2model-driven-application-660x410.jpeg 660w\" sizes=\"(max-width: 965px) 100vw, 965px\" \/><\/p>\n<p>On clicking the <strong>+<\/strong> icon you will get the <strong>search<\/strong> option (i.e. marked as C) and <strong>+ New relationship <\/strong>option (i.e. marked as D) as shown in the above screenshot.<\/p>\n<p>Using <strong>search <\/strong>(i.e. Option C in the above screenshot) you can search any existing table which relates to the account table and add it to the Navigation i.e. Related tab of the account form.<\/p>\n<p><strong>Add a new relationship <\/strong>(i.e. Option D in the above screenshot)<strong>:<\/strong><\/p>\n<p>Click on <strong>+ New relationship -&gt; <\/strong>and you can select the<strong> One-to-Many or Many-to-many <\/strong>options as per your business requirement:<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-33859\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/3model-driven-application.jpeg\" alt=\"model-driven application\" width=\"637\" height=\"391\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/3model-driven-application.jpeg 637w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/3model-driven-application-300x184.jpeg 300w\" sizes=\"(max-width: 637px) 100vw, 637px\" \/><\/p>\n<h2><strong>Edit relationship:<\/strong><\/h2>\n<p>Select the related table on the Main form,\u00a0 i.e. the <strong>Policies <\/strong>table from the Related tab of the <strong>Account<\/strong> Form, and Select the <strong>Edit Relationship<\/strong> option from the Right panel:<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-33858\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/4model-driven-application.jpeg\" alt=\"model-driven application\" width=\"1085\" height=\"701\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/4model-driven-application.jpeg 1085w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/4model-driven-application-300x194.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/4model-driven-application-1024x662.jpeg 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/4model-driven-application-768x496.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/4model-driven-application-660x426.jpeg 660w\" sizes=\"(max-width: 1085px) 100vw, 1085px\" \/><\/p>\n<p>Then edit the relationship as per your business requirement.<\/p>\n<h2><strong>Also, at the form level, we can hide the related tables:<\/strong><\/h2>\n<p>Select the related table on the Main form, i.e. the <strong>Suppliers<\/strong> and then Select the Hide option from the Right panel and click on the <strong>Save<\/strong> and <strong>Publish<\/strong> button as seen below:<img decoding=\"async\" class=\"alignnone size-full wp-image-33857\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/5model-driven-application.jpeg\" alt=\"model-driven application\" width=\"1090\" height=\"586\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/5model-driven-application.jpeg 1090w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/5model-driven-application-300x161.jpeg 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/5model-driven-application-1024x551.jpeg 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/5model-driven-application-768x413.jpeg 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/5model-driven-application-660x355.jpeg 660w\" sizes=\"(max-width: 1090px) 100vw, 1090px\" \/> <strong>Conclusion<\/strong><\/p>\n<p>Now, simply with the model-driven application form designer, we can add\/edit relationships of the table as per business requirements.<\/p>\n<p><a href=\"https:\/\/www.inogic.com\/product\/productivity-apps\/auto-manage-lead-assignment-and-distribution-automation-dynamics-365-crm\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"alignnone size-full wp-image-33863\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/Assign-and-Distribute-Leads-1.png\" alt=\"\" width=\"800\" height=\"200\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/Assign-and-Distribute-Leads-1.png 800w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/Assign-and-Distribute-Leads-1-300x75.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/Assign-and-Distribute-Leads-1-768x192.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2023\/01\/Assign-and-Distribute-Leads-1-660x165.png 660w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>As we know, usually, we needed to create a relationship of tables to make proper data management and show data in the application. So, generally before designing the model-driven application forms, we had to be sure the tables, columns, and the relationship between them was fine. But now, we need not worry about creating relationships\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.inogic.com\/blog\/2023\/01\/add-or-edit-table-relationships-using-the-model-driven-application-form-designer\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[2361],"tags":[2665],"class_list":["post-33855","post","type-post","status-publish","format-standard","hentry","category-technical","tag-model-driven-application"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/33855","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=33855"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/33855\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=33855"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=33855"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=33855"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}