> Why you don't want to let field to be null AND _use_ foreign key?

Another thing... I seem to remember that I read somewhere that when you do JOINS
is better -for performance- to always having a corresponded field in the join
table than using LEFT JOINS.

Of course... know I have the strong feeling that I was wrong again... wasn't I ?

-s