>I think I have my compound index set up correctly as follows:
>
>My Database fields look like the following:
>Field1 is Char 12
>Index is Field1 Regular
>Index Expression is Field1+Field2
>
>Field2 is Char 2
>Index is Field2 Regular
>Index Expression is Field2
>
>SEEKID = Database.Field1
>SELECT Database
>SET ORDER TO TAG Field1
>SEEK SEEKID
>
>But when I do a seek I only see Field1 unique records not any duplicate Field1 records that I want to see when pressing the Top, Prev, Next, and Bottom command buttons. What's wrong with this picture? Is it because my SEEKID is not Field1+Field2? If SEEKID is wrong, how should the SEEKID look? I'm spinning my wheels.
>
>I am new to compound indexes. Thanks for your help.
Steve,
Can you elaborate it more ? Do you use seek or skip (or alike) after the first seek to navigate. A simple seek is like this :
seekid = "value to seek"
lFound = seek(seekid,"mytablealias","mysearchtag")
scan while mytablealias.myfield = seekid
...
endscan
Cetin