2. PHPRunner General questions
  3. Drop Down Options (alphabetical)
This topic is locked

Drop Down Options (alphabetical)

 		2/1/2008 1:43:24 PM
PHPRunner General questions
powersitedesign author

I have a database table that stores "cities" that is a dropdown option in another entry form. Right now they are being displayed in the order they were entered into the database, I want to have them listed in alphabetical order in the drop down. How's the best way to accomplish this?
Thanks,
E
 		ewold 2/1/2008

In the lookup wizard on the edit/add Page in the visual design you have a field 'Order By'.

This can be ascending or descending.
Set 'Display field' and 'order by' to 'Cities'

Does this solve your problem ?
powersitedesign author 2/15/2008

Thanks, that did the trick!