>Cetin,
>
>In my many-side table I have an index called edri2 which is edr_no+edr_subno. These are both numeric fields. In the command window I type Set Order To edri2. When I browse the table the erd numbers are not always grouped together. Shouldn't the rdr numbers be grouped and then ordered by the edr_subno?
>
>Thanks Again,
>S. Dyke
Steven,
Isn't there any typo here ? If they're numeric and you use no conversion to char in that index expression than I can see what's happening.
Assume this. You have edr_no 1,2,3,....100 in parent. edr_no 1,2,...100 in child with edr_subno's 0,1,2,3.
Suppose you're on parent with edr_no = 7.
Child recs with edr_no (4,5,6,7) have a chance to match if their edr_no + edr_subno = 7 (ie: 4 + 3). Where ( 7 + 1) pair would fail to match and wouldn't be in grid. As a thumb of rule you should convert combined indexes to char type (unless doing it for some tricks):
index on padl(edr_no,8,"0")+padl(edr_subno,8,"0") tag main
* RelationalExpression - padl(edr_no,8,"0")
* ChildOrder - Main
* LinkMaster - ParentTable
Cetin