i'm not quite sure how to set this up...

i have fields section number, procedure number, section name, subsection name, and procedure name

they want it to be in a drop down like so:

sectnumber.procnumber sectname:subsection:procedure

they want it sorted by section number...

i've tried a couple of things. i have had it all going to one field as a string and then it sorts the numbers like they were text instead of numbers: 1, 11, 3, 4 instead of 1, 3, 4, 11

so then i tried having list get two values...the section number and then the other information...so then the numbers sorted right...but then when i only wanted certain sections...it still always showed all the numbers....and then only the right titles...like...

when i show all the titles it would show

1.2 blah

1.3 blah 2

2.4 marketing 1

2.5 marketing 2

3.4 blah 3

so that's good...but then when i want just marketing titles it shows:

1

2.4 marketing 1

3

kind of confusing...sorry. but what they want is a drop down of titles that includes all the information...they want drop downs for all of the titles...and also just for each section....

help? it's driving me crazy :confused:

well...worked around it...had only the main index list get the section number and title and sort by the section number...the other index lists for each section i just got a title and had the section number built into the concatenated string...not very tight...but it'll work.

any suggestions are good though if someone thought of any