how to add sql query data from another table to hidden field

Hi,
I working with chronoconnectivity v5.
I trying to build an application, where I use Selector and hidden fields in rows. Now I should get a latest Id from another table to all these hidden fields. Then it is possible to select rows and update these where I want to add relation to another table.

I have already did sql query and I get latest id informatio from another table. But the problem is that how could I add this latest id info from sql to hidden fields ?

This sql query it is in pre processing display window. Is it right place?

I'm newbie here, so sorry perhaps stupid questions.

-Paul

Hi Paul,

If you have a custom list display then you can find the matching row from your custom query results and add it, alternatively you can use Connectivity v6 and get the latest id value using a "hasMany" relation, that should be easier, adding the fact that v6 is better and has more features.

Best regards,
Max