Chandan,

In order to create structural CDX index use this command

index on bCode tag bCode && first you need to open the table exclusively

You do this command only once when you create the table

After that you can use

if seek(thisform.txtSearch.value,'myTable','bCode')

    Populate other textboxes with values from the table
    txtOtherField.value = myTable.OtherField
endif

>Naomi
>
>I have tried it but am getting an error message," Table has no index order set". I have used the line
>
>

>Index on bcode to mcode
>

>
>I have also tried by this
>
>

>Use bcode order mcode
>

>
>But when I am using the following command in the style of old foxdos, every thing is perfect.
>
>

>
>clea
>	close all
>	set talk off 
>	set safety off
>	set date brit
>	set cent on
>	close database
>	open database branch
>	use bcode
>	lnCode=0
>	
>	
>		STORE 0 TO gnCount
>		@10,10 say "Code:" get lnCode
>		read
>		
>	sele a
>	go top
>	index on code to mcode
>	seek  lnCode
>	if found()
>	*?code
>	?alfacode
>	?bname
>	else 
>	wait"sorry"
>	endif
>clear
>	@14,10 get alfacode
>	@16,10 get bname
>
>

>So, please help me.