>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