>>Can you post your tables creation script? Are you sure you have FK relationship properly defined? As a test, you can try to insert a record in the child table with wrong parent key and see, if you succeed.
>
>Thanks Naomi
>
>Yes if I try to insert a row in the child table I get a Foreign Key error.
>
>I've created a database diagram and that shows the FK relationship..
>
>Its just not showing up in the visual studio designer.
Strange. What is your VS version?
If it's not broken, fix it until it is.
My Blog