sorting a text box

3 posts by 3 authors in: Forums > CMS Builder
Last Post: October 18, 2012   (RSS)

By Mel - October 17, 2012

I have a record field called locations which is a text box

In the text box are a variety of location names entered in no particular order and with out any commas separating them

Each record has different location names and a different amount of entries in that field

Is there a way that I can sort these location names into alphabetical order when they are displayed for each record in it's present format?

Or do I need to be entering this data in a different way instead of a text box

Thank you - Mel

Re: [mel] sorting a text box

If I were setting this up, the locations would be stored in a related records table and I would use a multi-select list to choose as many locations that apply to that record. Then on the display page, sort the related records by name.
Ron Conring
Conring Automation Services
----------------------------------------
Software for Business and Industry Since 1987