The Requery() gets all the records for a specific person. What are the criteria for selecting record 3? Whatever the criteria, LOCATE for it. I'm slow, and that seems obvious, so you may need to explain more.
>Actually I am getting 4 records that match my criteria. What I need to do is have the ability to run another query locating a specific record in the 4 record set. I also want my navigational bar to scroll through all 4 records, even though I landed on record 3. Here is the code I used to obtain my 4 records:
>
>* b= persons name
>* c= persons id number
>* lc_p_inv_pid = parameter pass to query locating person by id number
>*
>do case
> case .a = 1
> .set_1p && sets control source for fields
> locate for alltrim(person_tbl.p_lname) = .b
> .c = person_tbl.p_inv_pid
> lc_p_inv_pid = .c
> requery('lv_1p')
> refresh()
>
>
>what do I do after this to locate a particular record in the above query result, such as record 3. I don't know how to get to record 3 in the result set above?
>
>thanks for reply
>
>nick patel
Charlie