How to get title of dropdown menu with chronoconnectivity

Hi,

On a form I have a dropdown item that is connected to a database table that is "sioa_demRelacion" with two columns (idRelacion,nombreRelacion) that are (value,title) of dropdown item.

When I submit the form, it saves the value of this dropdown item (idRelacion) on table "sioa_demandante".

When I show "sioa_demandante" with a table on chronoconnectivity it shows the value "relacion" stored on "sioa_demandante" (0,1,2,3 or 4) but I want to show for example "Internet" that correspond to 2 value.

How can I make this SQL query with 2 models on chronoconectivity:

SELECT 'sioa_demandante'.'nombre','sioa_demRelacion'.'relacion' FROM 'sioa_demandante','sioa_demRelacion' WHERE 'sioa_demandante'.'relacion' = 'sioa_demRelacion'.'idRelacion'

Thanks.

Hi yusufo,

I suggest that you replace 0, 1, 2, 3, 4 with the values that you want to use. Please see this FAQ

Bob