AnsweredAssumed Answered

Conditional line printing

Question asked by WilliamBartels on Feb 21, 2011
Latest reply on Feb 21, 2011 by philmodjunk

Title

Conditional line printing

Post

My database has records with a number of fields.  Two of these are FILED and COMMENT.  I want to set FileMaker to always print the first line, containing a selection of data.  If FILED is not empty, I want to follow with a line containg the FILED field.  If COMMENT is not empty, I want to follow with a line containing the COMMENt field.

 

xxx xx xxxx xxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxx (COMMENT and FILED both empty)

yyy yy yyyyy yyyyyyyyyyyyyyyyy yyyyyyyyyyyyyyyyyyyyyy ( COMMENT not empty but FILED is)

          Comment:  <contents of COMMENT field>

zzz zz zzzzz zzzzzzzzzzzzzzzzz zzzzzzzzzzzzzzzzzzzzzz  ( Both COMMENT and FILED contain data)

          Filed: <contents of FILED field>

          Comment: <contents of COMMENT field>

www ww wwww wwwwwwwwwwwwwww wwwwwwwwwwwwwwwwwww  ( COMMENT is empty but FILED is not)

           Filed: <contents of FILED field>

vvvv vvv vvvvv vvvvvvvvvvvvvvvvv vvvvvvvvvvvvvvvvvvvvvv  ( COMMENT and FILED both empty)

uuu uu uuuuu uuuuuuuuuuuuuuuu uuuuuuuuuuuuuuuuuu  (...)

Any assistance would be greatly appreciated.  The database is excellent, but the help facility leaves much to be desired,

Outcomes