>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
Mike,
I wouldn't use this.Value but directly alias.fieldname.
LOCAL lcNewSerial
lcNewSerial=myAlias.myField
SELE TABLE1
if INDEXSEEK(lcNewSerial, .f., 'Table1', 'SerialOrderTagName')
WAIT WIND "found" NOWAIT
ELSE
WAIT WIND "not found" NOWAIT
ENDIF
I couldn't understand second part of your question.
Cetin