Hi Cetin,

Im sorry if I didn't clarify my reply to you. Yes xbase command.
Anyway I tried this code and it works:

(thisform.grid1.column1.text1.lostfocus)

LOCAL lcNewSerial
lcNewSerial=THIS.VALUE
SELE TABLE1
INDEXSEEK(lcNewSerial)
IF FOUND()
IF RECNO() < 0
WAIT WIND "found" NOWAIT
ELSE
WAIT WIND "not found" NOWAIT
ENDIF
ENDIF


However, it doesn't work in one-to-many relationship.
Parent table has (drnumber index)
child table have (dr_number,serialno indexes)

Can you please help me with this..

Thanks again...

MIke