D
debbiebarton
Guest
how do I populate a table with records from another table but with the primary key from a further table, eg, I have a student table, a keyskills table (with numerous rows) and a KS achieved table which will hold the studentID and the records from the keyskills tables. Because of the volume of the students and the keyskills I do not want to have to key them in manually, is there a way to do it automatically? Initially I want to do it for all students in database, then only for new students. Any help would be very much appreciated