UNIQUE DATA INSERT IN THE FORM

[Shah]

I INSERT THE NAME IN THE FIELD THAT IS NOT UNIQUE.
I WANT NOT TO SAME DUPLICATE NAMES.
PLZ SEND ME IF ANY PROPERTY IN THE FORM EXISTS OR ANY CODE.

[ahmadbilal]

in form buider apply when_validate_item triger on name text item write code there

select count(name) into v_cnt variable name
from table name
where name = :text item name;

if v_cnt <> 0 then
raise form trigger failure


hope you can understand