Thanks ed for replying

but in which event/method of grid would i specify that.

>>hello
>>
>>i have a grid with three fields searchitem,beginitem,enditem.i want to find the begin and end items from another table and put in beginitem and enditem field.
>>
>>for example
>>if user enter 10100 in searchitem it should display 10000,14000 in the beginitem and enditem.
>>
>>it get the data from header table where the structure is beginitem and enditem
>>
>>10000-14000
>>14001-15000
>>....
>>
>>txs for any input.
>
>Create an index on beginitem and on enditem, and use LOCATE:
>
>LOCATE FOR searchitem>= beginitem and searchitem <= enditem