If my data looks like the following -

StudentID School Year CourseID CourseName
724260 2000-2001 8881 PE
724260 2000-2001 8881 PE
697660 2001-2002 8891 PE
697660 2001-2002 8891 PE
697660 2001-2002 8891 PE

I would like to make each record unique by addling a number to the
CourseID so that I'd end up with:

StudentID School Year CourseID CourseName
724260 2000-2001 8881-1 PE
724260 2000-2001 8881-2 PE
697660 2001-2002 8891-1 PE
697660 2001-2002 8891-2 PE
697660 2001-2002 8891-3 PE

How can I do this?

Thank you,

Sheldon Potolsky