Suppose I have this two tables;
Modules and Student
Modules has the following fields
- Module_Code(Primary Key)
Student has the following fields
- Stud_Number(primary key)
My problem is that I want to include the Stud_Number on the Modules table to make it a primary key.
Can anyone show me the right syntax to use because I have through the Documentations and still I cannot find the right syntax to use.