>If you're using FK constraints, you will not be able to have an FK of 0 unless there is actually a row with an ID of 0 in the parent table. OTOH, you can have a FK of NULL.
>
>-Mike
>
>>>>>Hi all,
>>>>>
>>>>>What is the advantage when we allowing Null data type to each data field?
>>>>>
>>>>Aston,
Thanks, Mike.
Then going back to the original question of this thread would you say that it is best to allow Nulls in foreign key fields? Otherwise you would have to maintain a default, meaningless record in the parent.
Regards,
- Glen -
The impossible we do immediately.
The miraculous will take a little longer.