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.