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
HTH,
Viv