External data group properties - Data fields tab
Applications module
External data group
1st column
In this column, you will see a symbol if a field is defined as the
Primary key or
Foreign key. If the
external data table contains a primary key, this will be identified
by Intrexx automatically. The primary key of an external data source will
be treated as a
string
field in Intrexx.
Title column
Title of the data field.
Name column
Name of the data field.
Data type column
Displays the
data type
that is used in Intrexx for the currently selected data field. Intrexx
recognizes the data type of the external data fields and automatically
assigns the appropriate Intrexx data types.
External data type column
Displays the
data type
that is used in the external data source for the currently selected data field.
Add
Opens a dialog where the fields of the external data source can be selected.
Primary key
Defines the currently selected data field as the primary key field.
|
A primary key should always be selected. Make sure that you use
data fields with unique values.
|
Foreign key
Defines the currently selected data field as the foreign key field. The field,
which is implemented as the foreign key, must contain a value that the
parent data records can explicitly be identified with; such as a customer
number.
Remove
Removes the selected data field from the list. If this is still used in the
application, an appropriate notification will be shown. The data field will
not be removed from the list in this case.
Edit
Opens a dialog where the title and name of the data field can be modified.
|
External data groups are always labelled with a red
symbol.
As usual, an external data group's data fields can be
shown from the
context menu Show data fields
and connected to edit and view pages.
|