Hello,

I am trying to figure out this:

I have database with lots of people. When I am printing list of those people, in each person i have two field for telephone and two for mobile, like this:

Tel1: 111 111 111

Tel2: 111 222 222

Mobile 1: 123 123 123

Mobile 2: 321 321 321

what I would like to do, is to hide field name (Tel1, Tel2, Mobile 1, Mobile2) if the field with that telephone number is empty. Because now, my printed list seems like this:

Tel1: 111 111 111

Tel2: 111 222 222

Mobile 1: 123 123 123

Mobile 2: 321 321 321

--------

Tel1: 111 111 111

Tel2:

Mobile 1: 123 123 123

Mobile 2:

Thank you for any suggestions.

The first approach might be to create the labels into calculations

label_tel2 (text) = if( isempty(tel2) ; "tel2" )

but I recommend to create a new table for all those numbers and place a portal on the layout with the possibility to enter every number of numbers of any type.

-jens