I've got a form that utilizes the comma separated menu to select multiple names from another table. The id from table x is entered into a cell in table y when selected. If multiple names are selected then multiple ids are entered into table y. This is working great!
However, my mysql is a bit rusty. The id in table x also has cells with the names of each record. Unfortunately when I display the recordset, it only shows me the first name, even though there are multiple id's in the cell.
I figure I just need to massage my mysql but don't know how.