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:
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
reg,
wolf
-
Does anyone have a solution?
-
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).