I have a query where there are 3 optional (long) text fields, lets call them field1, field2 and field3. Any or all of them might be empty and/or have text in them. Ideally if empty then the query row height would be a single row tall, if all were filled in then each one would be displayed one above each other, so the row should now be 3 rows tall. I do NOT want to just concatinate the fields, They need to display on separate rows if they have data.
Is there an easy way to do this in Aware?
Has anyone else done something like this?
(I feel that perhaps Javascript in the grid column would be the way to do this....)
Bruce
