>Hi,
> What do u mean by method to execute SEEK? Yes, I can post u the program file...but it quite long ...u may not know what I am doing!!! Anyway, I can explain further.
> I have a grid that showing table1. When user dbclick the row, my program will seek for certain addition and search records from 2ndtable. I issue seek(myvar,"mytable","mytag") / USE mytable ORDER mytag....SELECT mytable.....SEEK myvar.......in my AI part. The value in grid will disappear.......
> Any suggestion? or still need to check my program file??
>
>Thank you

John, what do you expect to have? Do you want still show table1 in grid or you want bring records from table2 to the same grid?