Empty rows in Dropdown ( Join)

[hsmdk]

I wonder why there are empty row in dropdown ( with database join)

Any one have a hint

 

[troester]

For testing you can set a "or Concat label" in your dbjoin element appending the value, something like
{thistable}.id,{thistable}.your-column

This is happening in a filter?
If you have set Filter data=recorded data it's showing empty labels if the record the stored value is pointing has been deleted.

 

[hsmdk]

Thanks for your reply. Its happen both in filter and in advanced search. Have now set it so it dont leave empty spaces - Thanks for the hint.