I am trying to retrive data from a sql server database and populate into my notes form combobox. i get it work by using @dblookup and a data source connection on client side.
what i really need is to let the server do the job instead of the client so that the implementation wont require all the client to create their own DSN and the query task can be carry out on server and pass the result onto the clients form(combobox)
i have read the Offloading LEI task to server but it i didnt get the clear picture involving @formula.
i tried to call a script/agent from the server by using formula on client side but domino wont allow me to do so.
can anyone show me the right path?