Multiselect listbox into multible fields in table

T

Tryggvi

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 | |
 
D

Douglas J. Steele

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.
 
R

Rob Oldfield

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....
 
Top