Importing multiple fields to one.
Hey everyone- very new to database creation here. I am trying to import multiple fields from one table to one field on a new table.
One table has actor names and characters they play in several shows. I need to take that information and create new table with one record for each actor character combination.
Thanks for the help