Multiselect listbox into multible fields in table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list box which user can select multible values.
Then I whan´t the values the user selects
in a table on multible field but in the same row.

Is this possible?

Example:

LISTBOX:
Ross
Joey <------Selected
Chandler
Monika <------Selected

TABLE:
ID | Date | Actor1 | Actor2 | Actor3 | Actor4
1 | 12.12 | Joey | Monika | |
 
Please note that your table isn't properly normalized. You shouldn't have
multiple fields like Actor1, Actor2, Actor3, etc. in a single row. Instead,
you should have multiple rows, one per actor.
 
Quite right. You set your table up for 'Friends' and then some git releases
'The Magnificent 7'... you redesign and then they make 'The Dirty Dozen'...
etc.... etc....
 
Back
Top