FKNULLValueCaption Property

The caption for the value to be used, if the column has foreign key relation but its value is NULL.

[Visual Basic]
Public ReadOnly Property FKNULLValueCaption As String

[C#]
public String FKNULLValueCaption {get;}

Remarks

For example if the value of CateogryID in the Products table is NULL and the FKNULLValueCaption is "No Category", then "No Category" will be displayed to the user for the value fo the CategoryID field.

There are several ways in which you can specify the description. For detailed information on the mechanism see Caption The extended properties of the database relation object are used.
The caption extended property is "SDBF_NULLValueCaption".
The caption resource id extended property is "SDBF_NULLValueCaptionResID".
The auto generated resource id has the following form - {FKRelationName}.NULLValueCaption, where FKRelationName is the database name of the relation.

FieldSchema.FKNULLValueCaption Property

Remarks

See Also