Currently, if you have a one-to-many relationship between two tables and the “many” field is displayed on a PDF Form, the field values are displayed on the PDF separated by commas like this:
Record1fieldvalue,Record2fieldvalue,Record3fieldvalue
I’d like to be able to list these values in the PDF Form each on a separate line, replacing the comma with a new line.
Record1fieldvalue
Record2fieldvalue
Record3fieldvalue
(See this example of Trucks and Trailers listed)
I think there would be many occasions where this display format would be preferential on a PDF Form.
I’m currently working around this by using a Pipe to get all the record value, copy them across to Parent Table and then using another pipe to add the values and line breaks into a RichText field but it would operate a lot quicker if it didn’t need to do these extra steps.