>Hi,
>
><<
>I need help with navigation. I have a table which has part numbers entered in random order the part numbers are like such. 117124,117124-001,117124-003,117125,117126,117126-001. When I use navigation on my form I need some method to make sure I get the part numbers with dashes to show up. Right now it will go 117124,117125,117126 etc.
><<
>
>Maybe:
>
>
>INDEX ON PADR(ALLT(CHRTRAN(Partno,"-","")),LEN(Partno),"0") Tag PartOrder
>
>
Or, simpler:
INDEX ON VAL(STRTRAN(Partno,'-','.') Tag PartNumOrder