>I don't use the builder but I see that as developer's own error who sets an FK to allow nulls and yet restricts inserts. As someone said 'nulls are evils'.
>Cetin
>
Cetin,
Here is the scenario: when I'm scheduling a new account in the Employee_Queue_Schedules table, I have two FK fields. One is the cTrans_Employees_Queus_fk, which is the foreign key to the real parent table. This is always should be set to the correct value. The other FK is cDiary_Code_fk. In other words, when you re-schedule, you can put a "mental" note to youself or your colleagues about why you're re-scheduling this account. I don't want to use a dummy value on my original insert. I want to be able to have NULL here, yet I don't want to allow wrong values. I believe, this is the behavior for SQL Server. Also this is current behavior of the native RI builder because of its internal bug. So, I think, it should be up to developer to control NULL situation on a case by case basis.
If it's not broken, fix it until it is.
My Blog