Datasheet

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization

Form Name Name of the form that contains the combo box

Field Name Name of the combo box

Query Name Name of the query used to fill the combo box

Replacements

Replaces expressions in the original SQL statement. This has been removed

in RAIS 3.0 SQL Server Extensions version

Queries used to fill combo boxes always must have the following column layout

Foreign key: the foreign key to be stored in the underlying field of the combo box

Label: the name to be displayed for the foreign key value (shall be unique)

The first field must always be a foreign key, which must comply with the relationship of the

combo box’s underlying field, i.e. if the underlying field of the combo box is generator

model, the relationship of this field clearly points to the table of generator models. The

foreign keys returned by the preselection query may only be keys of generator models, not

from any other information item. The first column is not displayed in combo boxes, but the

value of the first column is stored in the underlying field.

The second field shall be a human readable name, in the above example the generator

model’s name. It may be a combination from many other fields, it may for example include

the amperage and voltage. However you should take care that its value may always clearly be

identified, so displaying only amperage values for models to be selected would be a bad idea.

Only the second column is displayed in combo boxes, its value however is not stored.

2.5.1 Examples

2.5.1.1 Generator models for generators

Form Name SUB EDIT Generator

Field Name COMBO Model

Query Name Entry Filter – Generator Model

Replacements

2.5.1.2 Facility and department for generator history

Form Name SUB EDIT Generator History

Field Name COMBO Facility

Query Name Entry Filter – Facility

Replacements

Form Name SUB EDIT Generator History

Field Name COMBO Department

Query Name Entry Filter – Department

Replacements

2.5.2 Comments

Please take care that each input field shall only have one single query attached.