Hello, everyone.
I'm working on a movie database, and have imported an Excel spreadsheet with 497 records into a table.
The table is named tblMovies. That will serve as my parent table.
Two of the fields in tblMovies are named Actor Last Name, and Actor First Name. I want to copy these two fields, along with their entire contents, into a second table, named tblActors. These two tables will eventually be joined to a junction table, and I will be using the tblActors table in a subform.
Anyway, my question is simple: I am not 100% sure which is the easiest method to get those two fields from tblMovies into tblActors.
I've read an Access Knowledge Base article that recommends an Update Query.
http://support.microsoft.com/kb/209728
I admit I've never designed an Update Query before. Is this the best way to do this, or is there an easier method? According to the article, duplicate data such as this is not good database design. However, I plan on removing those two fields from the tblMovies table once they are shifted over into tblActors.
Any suggestions on whether or not I should do an Update Query? Since I've never done one before, can anyone recommend a beginners' step-by-step tutorial that demonstrates this? Thank you! Warren Page