sort drop downs

[NeoCryptic]

not sure if this is possible...or maybe it's a really simple answer...

i have a drop down that is generated from the values of a field. right now it sorts the numbers...but it goes

.

0

1

11

12

2

3

etc.

is there a way to make it sort a certain way so that it would go

.

0

1

2

3

11

12

etc.

thanks :P

[comment]

Change the source field's type to Number?

[NeoCryptic]

well...the field isn't just a number...it concatenates a string from 3 different fields...

i have a section#, procedure#, and regarding fields...and they all come together like so...

section: 3100

procedure: 3

regarding: color management

and then it goes to the index list like:

3100.3 color management

thanks for replying comment

any ideas?

[comment]

It's difficult to advise out of context, but in general it's best to stick to one fact per field. In any case, text sorts differently than numbers, so "11" comes before "2".

[NeoCryptic]

i'm only doing the concatenate because i use it as a drop-down menu that serves as an index of the procedures in the database so they can just select one and jump to it...no way to sort it this way then?

any ideas on how to do it differently?

he wants all that information to be in there in a drop-down...

[comment]

You could script this to show a portal or a list view of the candidates, then select by clicking.

If by "index" you mean a match value for a relationship, then you should consider using serial number IDs instead - but again, this is a general, out-of-context, advice.

[NeoCryptic]

okay...i was thinking a portal, too...but wasn't sure.

thanks again comment :P