Foriegn key just cant be made in my diagram!?

[Guest_imported]

I get the error message " The columns the in that 'blah' do not match an existing primary key or unique constraint"

I've checked that my table columns look the same design wise, what am I doing wrong?

all I want is a Fk in table B for the PK in Table A

Many thanks

Nit
NBC@Secretagent.co.uk

 

[thmarmot]

Uusally ,some data stored in the FK field of the Table B
refers to PK in table A that do not exist anymore.
if you execute this statement , you will se imedialtely
the wrong data

SELECT FK from B where fk NOT in ( select pk from A )

it is easier to create the link before filling the tables.

thmarmot