>>My code is this
>>
>>select clients
>>set order to tag accountno
>>seek left(globalnew.accountno,6)
>>if found()
>>WAIT WINDOW "A"
>>endif
>>BROWSE last
>>WAIT WINDOW "B"
>>
>>The seek never brings up window "A" but does bring up the browse which shows it has found the correct client record
>>
>>So its saying to me that it that it hasn't found the correct record but yes it has
>>
>>What have I done wrong
>
>What about this:
>
>SET EXACT OFF
>seek left(globalnew.accountno,6) IN clients ORDER accountno
>if found([clients])
> WAIT WINDOW "A"
>endif
>SELECT clients
>BROWSE last
>WAIT WINDOW "B"
>
It now works thanks
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing