populate a table

[dott]

i have two tables that are related by three fields.

is it possible to populate my new table with all the data in those three fields from my other table?

i tried an update query using a select statement as the update to but i didnt really know what i was doing and it didnt work out

any help would be great

thanks,

andrew

 

[dott]

hmm maybe this is even a question of normalization. i may be doing this wrong. i have a table with all of the people's information and i want to have another table which says which courses they have taken

i have firstname, lastname, and ID number in both tables

am i doing this right? Should i have to copy all of that info into both tables?

 

[dcx693]

If you have duplicate information like that in your 2 tables, it's a good bet it isn't normalized. Why do you need firstname and lastname in both tables? If the ID number is unique, it should suffice as a primary key for the people information table and as a foreign key in the course table. After all, more than one person can have the same first and last names, and each person can take more than one course.