My question is what's the easiest way to retrieve data from an sql database and populate a field in a form?
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 (126.96.36.199)
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)