>Thanks Cindy,
>
>I want to replace all the records from cpack in packslip where the courseids and studentids are the same. So if there are 10 records in packslip with course ID as ECE155 and studentid as 2345, and 10 records in cpack with the course ID as ECE155 and studentid as 2345, I want to replace all 10 records in packslip with the 10 records from cpack.
>
>Tyler

Hi Tyler,

Take a look at UPDATE-SQL in Help. I have an impression (I may be completely wrong) that your job could be done in one UPDATE statement.