I have a Table (Films) where I have a string of data separated by commas (Genre):
(Ignore the Dashes that indicates break between Columns)
Film - Year - Rating - Genre
Catch Me If You Can - 2002 - 9 - Biographical, Crime, Drama
Batman Begins - 2005 - 9 - Comic Book, Action, Adventure
Heat - 1995 - 8 - Crime, Drama
Ex Machina - 2015 - 8 - Sci-Fi, Psychological, Thriller
How can I put this one column into a new Table (called Genres) putting each part separated by a comma into a new Row like below:
Genre
Biographical
Crime
Drama
Comic Book
Action
Adventure
Crime
Drama
Sci-Fi
Psychological
Thriller
I'm wanting to do this so I can use the resulting table as a source for a Combo Box, this Combo Box will then be used to filter on the master Table while allowing wildcard results so partial matches are retrieved.
(Ignore the Dashes that indicates break between Columns)
Film - Year - Rating - Genre
Catch Me If You Can - 2002 - 9 - Biographical, Crime, Drama
Batman Begins - 2005 - 9 - Comic Book, Action, Adventure
Heat - 1995 - 8 - Crime, Drama
Ex Machina - 2015 - 8 - Sci-Fi, Psychological, Thriller
How can I put this one column into a new Table (called Genres) putting each part separated by a comma into a new Row like below:
Genre
Biographical
Crime
Drama
Comic Book
Action
Adventure
Crime
Drama
Sci-Fi
Psychological
Thriller
I'm wanting to do this so I can use the resulting table as a source for a Combo Box, this Combo Box will then be used to filter on the master Table while allowing wildcard results so partial matches are retrieved.
Last edited: