James,
I have a similar question about working around this multiple-line problem.
My inspection survey is assigned with a Sample Suite number that determines the number and type of samples that need to be taken as part of a survey. A specific Sample Suite can require multiple kinds of bottles that need to be collected. The pulldata table looks like this:
Sample Suite | Bottles Required |
---|
12 A | HDPE 250 ml, Preserved (HNO3), Filtered |
12 A | Boston 1 Ltr, Preserved (H2SO4), Unfiltered |
142 B | HDPE 250 ml, Preserved (HNO3), Filtered |
142 B | HDPE 500 ml, Preserved (HNO3), Unfiltered |
142 B | HDPE 500 ml, Unpreserved, Unfiltered |
142 B | Vials 40 ml, Preserved (HCL), Unfiltered |
1827 TXA | Boston 1 Ltr, Preserved (H2SO4), Unfiltered |
I just need a way to display these multiple lines to the user to show them what kind of bottles they need to collect given a certain sample suite number. These values don't have to persist with the record.
I was able to concatenate the Bottles Required per Sample Suite:
Sample Suite | Bottles Required |
---|
12 A | HDPE 250 ml, Preserved (HNO3), Filtered Boston 1 Ltr, Preserved (H2SO4), Unfiltered |
142 B | HDPE 250 ml, Preserved (HNO3), Filtered HDPE 500 ml, Preserved (HNO3), Unfiltered HDPE 500 ml, Unpreserved, Unfiltered Vials 40 ml, Preserved (HCL), Unfiltered |
1827 TXA | Boston 1 Ltr, Preserved (H2SO4), Unfiltered |
but the carriage returns don't translate back to the survey and if I concatenate them all in the same line, the format is messy.
Anything I should try?