If you have the code ordered correctly, the record set will be created before the insert occurs, this will allow you to look up the value in the recordset and only perform the insert if the recordset is not empty. 
Thanks Jason,
So it would have to be hand coded .... its not something that Data Assist has in it?
Brad


