Please do not top-post.
Bèrto ëd Sèra wrote:
>> An immediate question: did you check that Key (docuuserid)=(8415) is
>> actually present in table "trade"?
Ljubomir Erdeljan wrote:
> This relate to different column names
> docuuserid is column in porder1 but relate to tradeid in trade.
You missed the point. Did you check that the key is present in "trade"?
IOW, is there a row in "trade" with "tradeid" equal to 8415? If not, you
cannot create the foreign key because the item in "porder1" cannot point to it.
--
Lew