Retrieve search value from SQL database

+7

Hi all

My question is what's the easiest way to retrieve data from an sql database and populate a field in a form?

Example:

User types project code "12345"

User clicks "Find" button

Form retrieves and writes the result into the project name field on the form: "12345 - Project A"

I can see an SQL request control but not sure if this can all be done by configuring that or if it's more complicated.

version: Enterprise 2013 (2.10.2.0)

Thanks

Userlevel 5

+14

yes, that should be proper control for your.

you even need not to make users click on a button, the control allows you to build a query that automatically follows value in other control(s)

Sign up