>>
>>BTW If the NULL values are NOT needed at all I prefer to set default value to empty field (depends of its type). Only type that allow NULLs is datetime :-)
>>Of course this is dependong the application, sometimes NULLs are mandatory.
>
>Borislav, I came across an issue with the NULLs and may have to adapt the same approach you have - setting default value instead of NULL. If you don't mind, I would like to ask you how you hide the record/row in the parent table with the empty/default field from the user? TIA.

Can you please elaborate on your question? What do you mean by "hide"? One way would be to do an inner join and so don't include such records at all.