[erikndp]

I have some doubt in triggering fire time.
I want to fire trigger after any field of DynaForm is it possible, means user enter first field in DynaForm and depending on that case variable value i want to fire trigger for rest of fields .

Let say in detail:
I’m using external database oracle 10g .
I want to create one DynaForm in which employee just enter emp_no on 1st field and rest of detail will fetch from database and DynaForm auto fill. (Name, address) etc.
I know it can be done by "DEPENDENT FIELD" facilities in DynaForm.
Now the real issue comes.

Dependent field always execute query as per emp_no's each character type .
Let say
emp_no 1 name kandarp
emp_no 11 name jalpa
emp_no 111 name rohit

DynaForm field (2)
empno - dependent (name)
Query ( select name from emp_master where emp_no = @@empno)

Not these query fires all time when user want info of 11.
It first gives info of 1 then 11.
so this make process slow as well as inflexible .
i want some solution .
like i can run some trigger or etc. like after fixed no of character type query will generate etc.
Help me.

[liliana]

Hi,

Have you checked this documentation?

Regards.

[gcleaves]

The database lookup is triggered onkeyup (for each character you type) probably because you have data validation (interger?) for the emp_no field. If you remove data validation, the dependant SQL will only fire when you leave the emp_no field.