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

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

Back
Top