How do I create multiple foreign keys in access
![]() |
How do I create multiple foreign keys in access
You don't "create" foreign keys. A foreign key is a field in a related table that contains a key value of the parent table. For example, in a student database, The StudentID is the primary key of the student table. If you want to show what students are registered in a class, you would add StudentID as a foreign key in your class sessions table.
You can have as many foreign keys as you need in a table. Using the above example, your class sessions table might have foerign keys for the teacher, course, location etc.
All times are GMT -7. The time now is 06:09 PM. |