I have a field on one of my tables that is nullable. The type is uniqueindentifier (Guid). It is a foreign key to another table (so it 'points' to a uniqueidentifier field in another table). Since this field is nullable, that are times when I want to insert a record and not have a value in this field. The only way I can get this to compile and run is to have this field set to Guid.Empty. The problem with this is that when I insert the record, of course I get the foreign key violation because LLBL is inserting this record with a guid that has a value of "00000000....", and there is no record in the other table that is part of the foreign key relationship with that value. There has to be a way to set a Guid field to null. If I try and set it to DBNull.Value, I get an error saying it's not the right type.
Any help would be greatly appreciated.
Mike
