>>>SELECT * FROM MYTABLE WHERE CNAME$CTITLE INTO CURSOR TEMP
>>Thank you so much for your response. I tried it but it still gives me 0 records from the valid event, but works from a .prg...
>
>Have you checked the value of CTITLE before your SQL to make sure it really contains the value you want to search for. If you do SELECT * FROM MYTABLE INTO CURSOR TEMP, does it work?

Yes, it does. I also tried WHERE conditions for the other fields in the table , works. Only using the wild card in the valid, returns 0. It worked when I put it in the activate event of the page!