[leokamal]

Hello

Here under the query but b4 that i am assuming that the table has an index column. lets say EMPNO in employees table.

Query ...

Select Count(empno) into :rec_count_txt from employees.

But if your form table is not indexed then you can use * in place of field.

Select count(*) into :rec_count_txt from employees.

but the most important thing is where to place the triger. well you should use this triger on block level.

take care,

Bye Bye