This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
hi in case of master details , your parent table is holding the primary key and you are refernig this priamry key , as a forign key in child table , if this is te case then it is not possible ,
if you are able to inserth the null in parent table then you can do this but as per my guess you can not insert the null i primary key ,
but you can define the unique key intead of defining the primar key. then it accept the null value.
Joined: Aug 27, 2003
Thanks Santosh, One of the guys working in the project has come out with this idea of having a special row in the parent table having all - (hyphens). This would allow the rows in the child table to contain - (hyphen) value in the foreign key column for those rows which do not have a valid foreign key. The business layer would interpret the - (hyphen) differently.