Hi there, I have two tables Table 1 contains a number of ‘original comments’ on a document and Table 2 contains ‘secondary comments’ which are made on the original comments. Not all original comments have secondary comments associated with them while some have multiple secondary comments.
Using a page I want to display all original comments and their secondary comments. This I can do however the page combines all of the secondary comments onto one line which makes the data difficult to read. Ideally, I would have a new line for each secondary comment even if that means that the original comment is duplicated.
Using an example from the Knack help on the attached screenshot, the supplier information is combined into one row for each Name when I want a row for each supplier with even if it replicates the Name three times