in the invoice form, where I enter the items, my client wants me to issue a warning if I enter the same item twice.

so I add this code in the valid event:

select stock_id from vinvdetail into curs temp where stock_id=this.value
if _tally<>0	
   wait windows 'This item already exist...' timeout 1
endif

the problem is when the operator moves the cursors between items, the message always shows up, because it detect it own record.

how can I detect it except the record itself.

thanks for the help.