0 Replies Latest reply on Jul 25, 2008 8:19 AM by (Peter_T2)

    Comma Separated Menu  - view multiple names

      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.

      Any suggestions?

      I figure I just need to massage my mysql but don't know how.

      thanks in advance!!!