To what Barry has written let me add that if the primary key is autonumber then the foreign key field (it is often helpful to give it the same name as the corresponding primary key) can only be a number field (long integer). The primary key is established in table design view, but the foreign key exists only through its relationship to the primary key. More on that in a moment. Note that