Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Access (https://www.askmehelpdesk.com/forumdisplay.php?f=441)
-   -   How do I create multiple foreign keys in access (https://www.askmehelpdesk.com/showthread.php?t=281824)

  • Nov 17, 2008, 03:02 AM
    itnerd
    How do I create multiple foreign keys in access
    How do I create multiple foreign keys in access
  • Nov 17, 2008, 06:45 AM
    ScottGem

    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.