>I am trying to use a compound or structural index for the very
>first time. Here is my question:
>
>What goes in the SET ORDER TO TAG _ _ _ _ ?
>
>I prepared these fields in the DB Designer and
>I have DB fields with indexes as follows:
>
>Field1 with an Index of Field1 and an Expression of Field1+Field2
>Field2 with an Index of Field2 and an Expression of Field2
>
>How do you refer to the Field1+Field2 in the SET ORDER TO TAG command?
>
>Can I refer to just the Field1 part of the Field1 index or what?
>
>I have like ID numbers in Field1 and I have Part numbers in Field2,
>but the ID numbers in Field1 are not unique so that makes this a
>little tricky to me. Because I want to step through all records
>for each ID and Part Number combination when I'm doing Top,
>Bottom, Prev, Next. So far it's been skipping the duplicate ID
>records and not showing me the other records with like IDs.
>
>Any help would be appreciated. THanks so much.

Actually, you create tags with 'Name' and 'Expression', i.e. in your example 'Field1' is tag name, and 'Field1+Field2' is tag expression, which is Ok for character fields, but not for integer fields (use str(field1)+str(field2) instead).
SET ORDER TO TAG Field1
will make table ordered by tag expression