AxpDataGrid.AddEditLookup Method

Add lookup fields to the Data Edit Form. These fields will be displayed with a drop down list in the Form.

[Visual Basic]
Public Sub AddEditLookup( _
   ByVal FieldName As String, _
   ByVal LookupTable As String, _
   ByVal LinkField As String, _
   ByVal DisplayField As String, _
   ByVal OrderBy As String, _
   ByVal AllowNulls As Boolean _
)

[C#]
public void AddEditLookup(
   string FieldName,
   string LookupTable,
   string LinkField,
   string DisplayField,
   string OrderBy,
   bool AllowNulls
);

Parameters

FieldName: Database Field (Column) Name
LookupTable: Database Table Name for the table containing the look-up values
LinkField: Database Field in the Lookup table matching the FieldName
DisplayField: Database Field to be displayed in the Drop-down list. Can be the same as LinkField.
OrderBy: If supplied the drop-down list will be sorted on this Database field (in the Lookup table)
AllowNulls: If True, AxpDataGrid will update the Table field with a NULL value if the user selects a blank entry in the Drop-down.
The database relationship and validation rules must be set accordingly obviously.

AxpDataGrid.AddEditLookup Method

Parameters

See Also