relationships without primary key HELP

[N1ck9141]

is there any way of creating relationships between two tables where i go from

table1 primarykey
to
table 2 notprimary key

however hav it show on the table2 the one without the primary key like the little plus thing because at the moment it will only show on the table where i have selected the primany key colum

 

[neileg]

Not really sure what you're asking. Each table should have its own primary key. When you relate two tables you do so by holding the primary key of one table as a field in the second table. This field in the second table is not a primary key and is referred to as a foreign key (because it is a key value from another table).

Why do you want a little plus thing?