>I have a table called Enroll with fields stud_id and course_code.
>I want to set both of them as primary key.
>Is there any way yo do it? coz i don't know how to select 2 fields for the expression of the primary index. thanks
You might also consider using a serial number as primary key. That way, the foreign key in other tables is shorter, joins are simpler, and you don't have to propagate changes made by the user.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)