Lookup bug

When i use a lookup for retrieve values and i use this SQL:

SELECT TipoAtencion
FROM tabla_tipoatencion
WHERE ID = {TipoAtencion}
ORDER BY TipoAtencion

For ID = 2 (for example) tha correspond “Manuel” the grid show me:

“2 Manuel”

and not:

“Manuel”

Is this a bug?

Thanks!

No, this is standard behaviour.

As I can do to make it look just the description and not the ID?

Usted debe agregarle el nombre del campo Nombre como segundo combre del campo:

SELECT TipoAtencion, NombrePersona