Hiya Bud ---
Is show fk a filtered or unique index?
>I am playing around with set key vs set filter and ran across this. I set key then seek on a different tag and it fails. I set filter and seek and it works.
>
>*Sample code
>use exhiinfo
>set order to showfk
>set key to 6
>?seek(3, 'exhiinfo', "Accnum") && fails
>
>set order to accnum
>* this will locate a recordd that is outside the set key range
>?seek(3, 'exhiinfo', "Accnum")
>
>set key to
>
>set filter to showfk = 6
>locate
>?seek(3, 'exhiinfo', "Accnum") && this works
>
>Anybody seen this before. Am I using set key wrong?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05