order of items in a drop down list KLaw 10.07.2006 21:07:02 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.

RE: order of items in a drop down list S.Y.M. Wong-A-Ton 11.07.2006 17:58:01 Review this thread http://groups.google.com/group/microsoft.public.infopath/browse_thread/thread/465cb368a5a1e56a/a5951e64f2c3fa38#a5951e64f2c3fa38 and see if there are tips there that might help you. Pay particular attention to the post by wina. --- S.Y.M. Wong-A-Ton "KLaw" wrote: [Quoted Text] > 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.

RE: order of items in a drop down list KLaw 11.07.2006 21:36:02 Perfect! Exactly what i was looking for - Thanks! "S.Y.M. Wong-A-Ton" wrote: [Quoted Text] > Review this thread > > http://groups.google.com/group/microsoft.public.infopath/browse_thread/thread/465cb368a5a1e56a/a5951e64f2c3fa38#a5951e64f2c3fa38 > > and see if there are tips there that might help you. Pay particular > attention to the post by wina. > --- > S.Y.M. Wong-A-Ton > > > "KLaw" wrote: > > > 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.

RE: order of items in a drop down list GBright 04.08.2006 18:38:02 Help - I did the below and it did not solve the problem for me. What else can I try? GBright "KLaw" wrote: [Quoted Text] > Perfect! Exactly what i was looking for - Thanks! > > "S.Y.M. Wong-A-Ton" wrote: > > > Review this thread > > > > http://groups.google.com/group/microsoft.public.infopath/browse_thread/thread/465cb368a5a1e56a/a5951e64f2c3fa38#a5951e64f2c3fa38 > > > > and see if there are tips there that might help you. Pay particular > > attention to the post by wina. > > --- > > S.Y.M. Wong-A-Ton > > > > > > "KLaw" wrote: > > > > > 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.

RE: order of items in a drop down list S.Y.M. Wong-A-Ton 04.08.2006 19:31:02 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. --- S.Y.M. Wong-A-Ton "GBright" wrote: [Quoted Text] > Help - I did the below and it did not solve the problem for me. What else can > I try? > > GBright > > "KLaw" wrote: > > > Perfect! Exactly what i was looking for - Thanks! > > > > "S.Y.M. Wong-A-Ton" wrote: > > > > > Review this thread > > > > > > http://groups.google.com/group/microsoft.public.infopath/browse_thread/thread/465cb368a5a1e56a/a5951e64f2c3fa38#a5951e64f2c3fa38 > > > > > > and see if there are tips there that might help you. Pay particular > > > attention to the post by wina. > > > --- > > > S.Y.M. Wong-A-Ton > > > > > > > > > "KLaw" wrote: > > > > > > > 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.

RE: order of items in a drop down list GBright 04.08.2006 19:56:03 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/[ at ]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" wrote: [Quoted Text] > 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. > --- > S.Y.M. Wong-A-Ton > > > "GBright" wrote: > > > Help - I did the below and it did not solve the problem for me. What else can > > I try? > > > > GBright > > > > "KLaw" wrote: > > > > > Perfect! Exactly what i was looking for - Thanks! > > > > > > "S.Y.M. Wong-A-Ton" wrote: > > > > > > > Review this thread > > > > > > > > http://groups.google.com/group/microsoft.public.infopath/browse_thread/thread/465cb368a5a1e56a/a5951e64f2c3fa38#a5951e64f2c3fa38 > > > > > > > > and see if there are tips there that might help you. Pay particular > > > > attention to the post by wina. > > > > --- > > > > S.Y.M. Wong-A-Ton > > > > > > > > > > > > "KLaw" wrote: > > > > > > > > > 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.

RE: order of items in a drop down list S.Y.M. Wong-A-Ton 04.08.2006 20:40:02 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. --- S.Y.M. Wong-A-Ton "GBright" wrote: [Quoted Text] > 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/[ at ]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" wrote: > > > 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. > > --- > > S.Y.M. Wong-A-Ton > > > > > > "GBright" wrote: > > > > > Help - I did the below and it did not solve the problem for me. What else can > > > I try? > > > > > > GBright > > > > > > "KLaw" wrote: > > > > > > > Perfect! Exactly what i was looking for - Thanks! > > > > > > > > "S.Y.M. Wong-A-Ton" wrote: > > > > > > > > > Review this thread > > > > > > > > > > http://groups.google.com/group/microsoft.public.infopath/browse_thread/thread/465cb368a5a1e56a/a5951e64f2c3fa38#a5951e64f2c3fa38 > > > > > > > > > > and see if there are tips there that might help you. Pay particular > > > > > attention to the post by wina. > > > > > --- > > > > > S.Y.M. Wong-A-Ton > > > > > > > > > > > > > > > "KLaw" wrote: > > > > > > > > > > > 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.