>I am using the following to find a matching client number....
>
>Seek(This.value,'client','clientnum')
>
>Once I locate a match, I need to check a subsequent field for a secondary match (firmid). If this record does not match the firm as well, I need to search for the next match of the clientnum and check the firm and do this until the clientnum is no longer found. How would I do this?
You can use LOCATE for on the first incidence and CONTINUE for each one thereafter testing to see if found. CONTINUE works on same condition until another LOCATE is issued.
If you use SCAN FOR x=something AND y=something, VFP puts a filter on the table which slows down the process. It is also assumed that x & y are indexed expressions so you get Rushmore optimization.
HTH
CySolutions, Medical Information Technology
You're only as good as your last
success, so . . .If it works. . .don't fix it!