0

Many-to-Many relation: how to create lists for printing

Hi all,

topic "Many-to-Many Tables for Printing"

I'm using successfully the recommended approach of following threads to model many-to-many (m:n) relationships between two tables:

https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/many-to-many-relationships-5cdae71cfdf7f57862667560

https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/creating-many-to-many-relationship-between-two-tables-5c4cc21e69b4e7067d2aea1b

However, in the moment you would like to create a table view where one column displays the linked many relationship there is no field available that you can drag into the view. In other words, inserting linked fields into the editor view works great, but displaying all entries in a list does unfortunately not work.

Is there a way to achieve this?

Here's a test ninox db used to demonstrate: https://www.dropbox.com/sh/0ivtqko5002uwvf/AAC_MXZqoFK2Y59SgC_eHOLga?dl=0

many to many

reg,

wolf

2 replies

null
    • TU Berlin
    • Christoph_Sander
    • 1 yr ago
    • Reported - view

    Does anyone have a solution?

    • Alain_Fontaine
    • 1 yr ago
    • Reported - view

    There is nothing below "MN relation" because that table does not include any data field. Drag a formula (first item in the list on the right) into the list on the left. Open the formula definition: you will have more options to define the value. Be careful to avoid producing a formula that returns an array of items, as this will not work (no warning, the column just disappears).

Content aside

  • 1 yr agoLast active
  • 2Replies
  • 643Views