New List Box using Explode

lyleholc · Post by **lyleholc** » Wed Jul 24, 2013 3:58 am

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

mobhar · Post by **mobhar** » Sat Aug 10, 2013 1:10 pm

My suggestion: try to play with the Master/Detail in order to display it.

Create a new database view that will hold the data that contains the master recordset (exclude the longtext field)
Create a new database view that will hold the data that contains the detail recordset (including the longtext field).
Of course, you have to make the connection between the master and detail via the certain key field(s).