Multiselect listbox into multible fields in table

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top