itnerd
Nov 17, 2008, 03:02 AM
How do I create multiple foreign keys in access
ScottGem
Nov 17, 2008, 06:45 AM
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.