Hello,
Please i have a control application of which i want to lookup a value from another table after a select and autofill a textbox field.
On Validate Success Event:
$this_thing="";
$sql=" SELECT something from some_table where something ";
sc_lookup(rs, $sql);
if (isset({rs[0][0]})) // Row found
{
$this_thing= {rs[0][0]};
}
{textbox_field} = $this_thing;