How do you change the sort order for a conditional drop-down?
It's displaying them alphabetically. That doesn't work for my situation. I need to specify the sort order. Is there a way to do this?
Forum Discussion
I have a numeric filed included in the table that is used for sorting (works well in the reports). I also have a Size Category (which is the "condition" for the drop down). Examples of conditions are (Apparel, Footwear, Headwear... etc).
When the user selects the product, the related size category filters the drop down so the correct size ranges appear. Where I'm losing it is with the sorting in the CDD. It seams to ignore the sorting rules on the report.
Record ID | Size | Size Sort | Size Category
Would a work-around be to create a different table for each size category? Then it would make more sense to have the picker show the Record ID# and then list them in size order in the table. However, I don't know if it would be possible to change the source for the CDD based on a field selection (product) which has a the related Size Category.
Thanks for any suggestions.
Mark
When the user selects the product, the related size category filters the drop down so the correct size ranges appear. Where I'm losing it is with the sorting in the CDD. It seams to ignore the sorting rules on the report.
Record ID | Size | Size Sort | Size Category
Would a work-around be to create a different table for each size category? Then it would make more sense to have the picker show the Record ID# and then list them in size order in the table. However, I don't know if it would be possible to change the source for the CDD based on a field selection (product) which has a the related Size Category.
Thanks for any suggestions.
Mark