Muddiest Point 3

This week's lecture and lab seemed to be rather straightforward, but if I had to choose something to ask about for me detail; it is how does a database make the distinction between a primary key and foreign key? I know that there is a difference between what each does, but how does the computer know that the primary key is the one to go to, and not the foreign key for a task/job/whatever?