>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?
Edward Pikman
Independent Consultant