Re: error message

[Phillip Ward]

Does this query return any rows?

select * 
from province 
where Country not in 
( select Country 
  from country
)

If it does then you have countries in your province table that don't appear in your country table and the foreign key is objecting to this - because that's its job!

Regards, Phill W.