Dear All,
I have a MySQL table that has a longtext field in each record. Records are displayed in a listbox. I'd like to have a list box adjacent or below the main list box, that would contain the longtext field contents EXPLODED and be sortable and filterable too. This way as the user scrolls through records, the list box would display the related exploded longtext data from the same table. The longtext field uses semicolons as the separator. I don't know how to go about creating such a list box. It's kind of like a details file, but from the same table.
Any suggestions much appreciated.
Thanks in advance!!
Lyle