User interface - Mapping many to many relationship

Hi,

We have a requirement for a Form in terms of multiple materials (Items) can have multiple attachments.  Further elaborating this, on the line level, there would be a table where users are able to add multiple items.  For the same added item, there would be a link where once clicked, it will open another table referencing the same item - where users can upload multiple attachments.

Does anyone have a sample whereby for 1 item, tag all uploaded attachments to that item.  I am thinking this would involve nested CDT.  Some suggestion would be great. Thanks

  Discussion posts and replies are publicly visible

Parents
  • Nested CDTs are better avoided. You may create different tables with Foreign Key constraints. In the first table you can have a column with link. On click , you may show a dynamic section below the table relevant to this row . In this section you can add multiple files or data. To manage the mapping , you can have a temporary keys hidden from the user.
Reply
  • Nested CDTs are better avoided. You may create different tables with Foreign Key constraints. In the first table you can have a column with link. On click , you may show a dynamic section below the table relevant to this row . In this section you can add multiple files or data. To manage the mapping , you can have a temporary keys hidden from the user.
Children
No Data