How to not display one particular value in a field?

Discussion created by MauriceG on Aug 25, 2018
Latest reply on Aug 28, 2018 by MauriceG



I’m using FM16. In a layout based on table TEX__Texts, I’m displaying the author’s name with a Author field from table AUT__Authors. When the text has more than one authors, I’ve created another field (OtherAuthors, calculation) in the TEX__Text table, the intention being to have this field display the name of the other authors except the one that is shown in the Author field. The calculation in that field is Substitute ( List (tex__AUT__Authors::FullNameAuthor ) ; "¶" ; "," ). This calculation displays all the names, so either it is the wrong calculation or it is incomplete. How do I change it so that the one author in the Author field is not displayed.