use sales in 0 alias sales select sales set order to inv mkey='003333' seek mkey scan while inv=mkey disp PK endscan use in salesand I got all the records.
select sales seek mkey order invwill automatically set the order, while it's not. I should do:
select sales set order to inv seek mkeyregards,