Hey Christof,
You know, that is why you just have to love VFP... if there is one way of doing something, VFP will give you about a dozen others, geez.
Actually, based on this statement, isn't this to process all the matches for those expressions. In my scenario... there is either one record that matches or none. There should never be more than one match.
>Hi Pete,
>
>>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?
>
>Sounds like you need something like:
>
>SCAN FOR ClientNum=This.Value AND FirmID=xxxx
> * Do something with the matching records.
>ENDSCAN
>
>Christof
Peter Brama
West Pointe Enterprises
VFP is getting easier but STILL alot to learn!!