u can do this to check if a value exists :
fire an SQL query before the the INSERT statement to check whether the value exists :

select count(*) VALEXISTS from tablename where fld = 'fldvalue'
[download]

if the value does not exist, the VALEXISTS column will be 0. depending on this value, u can decide whether to fire the INSERT statement or not
:-)