Insert null record in child table

[JtheRipper]

Hi there,

Is it possible to create a foreign key relationship to be able to insert a record with null values (on the FK colum) on the child table?

The reason is that the process that loads the data in the database loads some records in the child table before the parent table. I know it is crappy, but it is the client's request and we have 0 control over this.

Thanks,
J.

 

[JtheRipper]

Hi,

Sorted out my "problem"... looks like you only need to set the foreign key column to be nullable.