Identical entries in VL

[stevie.at]

If you have a VL consisting of an ID and a calculated names field, only 1 value will appear in the drop down if there are two ore more identical names in the database.

Is there an elegant way of workaround to show all these valid values?

I use to trim all values used in the calc-field for good reasons so blanks don't work in this case.

Maybe include a 3rd field into the calculated field...what I actually want to avoid.

Another thing to consider is there are hundreds of records without any name (like the main address of companies without a personal contact) I don't want to show up in the drop down if there's a workaround to really show up all entries...