Hi everyone,

I have this form which is just to enquire the data of the staff and display
it on the screen. In the form, there is a textboxt to keyin the staffid.

Then I will check the id as below :

The staff will keyin the id which is the staffid.
The fstaffid is the one found in the familyview

store staffid to value1

use familyview &&to check the family members of the staff
select * from familyview where value1 = fstaffid into cursor famtest

do while '&value1' $fstaffid
   display the data
skip
enddo

The thing here is the fstaffid is pointing to record 1 in the familyview. You
would not believe it when I took out the cursor famtest, the whole list of my
required data is there but my pointer is pointing to the familyview but I do
want my pointer to go to the select statement where I've found the data.
What could be the issue here....as i'm still a novice to foxpro 9.

Thanks for the assistance.