Fig. 152: SFormattedField Icons
Fig. 152: SFormattedField Icons
The SFormattedField can display, edit and filter data records. When the SFormattedField has its own data source and a reference to a STableElement that should be filtered, then the STableElement will be filtered by the data source of the SFormattedField.
Example:A STableElement1 is connected with the datasource Personen. TheSFormattedField has a reference to the column Nachname as data source. An other STableElement2 has the client information. When the SFormattedField is used as filter for the second STableElement, so only the records of the second STableElement will be shown, that values in the column Nachname comply with the current value of the first STableElement.
Overview of settings:
| TableSource | STableElement1 |
| ControlSource | Nachname |
| FilteredTableSource | STableElement2 |
| FilteredControlSource | Nachname |
The property DefaultValue defines the default value when creating new data records.When this value is set to null, the new value will be set to the null value, when the according table column accepts null values.
Standard Beans
SFormattedField Properties