order of items in a drop down list

[KLaw]

I am working on a form which has a drop down box of products which are
filtered by manufacturer. Is there a way to change what order the list
appear in? Right now it seems rather random - the items do not appear in the
order that they are in on the reference table and they aren't alphabetical.
I appreciate any help that anyone can give.

 

[S.Y.M. Wong-A-Ton]

Review this thread

http://groups.google.com/group/micr...368a5a1e56a/a5951e64f2c3fa38#a5951e64f2c3fa38

and see if there are tips there that might help you. Pay particular
attention to the post by wina.

 

[KLaw]

Perfect! Exactly what i was looking for - Thanks!

 

[GBright]

Help - I did the below and it did not solve the problem for me. What else can
I try?

GBright

 

[S.Y.M. Wong-A-Ton]

Can you describe a bit more what your scenario is like and what you have
already tried doing? If you're using a database, you could create a View (in
SQL Server) or Query (in Access) do the sorting and then bind your drop-down
to this view or query instead of a table.

 

[GBright]

I have a SQL View (query) which contains many fields, nine of which I want to
use to populate nine different drop-down lists on an InfoPath form. I want
each drop-down list to show unique values in alphabetical order. I would
rather not create nine separate views (one to sort each field) as that would
mean nine extra data connections (which slows down the InfoPath response
time). I can get each drop-down list to be unique by employing a Filter
Condition of not(.=../preceding::d:view-name/@field-name; but I cannot get
each drop-down list to alphabetize independently.

I hope you can help (I've enjoyed reading a lot of your other posts; even if
you can't address this issue, you have already indirectly helped me with
others)

 

[S.Y.M. Wong-A-Ton]

Is coding an option? If you want to stick to one Data Connection, you could
use this in for example the OnLoad of the form to populate the drop-down list
boxes. You'd have to add 9 repeating groups to your form and bind a drop-down
to each group. Then you can retrieve the XML data pertaining to the Data
Connection in the OnLoad, sort it on a column (see Asset Tracking sample
form), filter out the unique values, and populate each repeating group. Not
sure if the performance won't suffer, though.

And I'm glad my previous posts helped you in other areas.