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.
Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site:
www.stephenkramer.comWould you believe Far Side Lite?
More than 270 original cartoons.