Datasheet

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization
24
If a combo box field has no query attached, RAIS automatically detects the foreign table this
field is bound to and creates a query for displaying the first two fields of that foreign table.
Ordering will always be ascending on the second field.
Please note that [Replacements] are not used anymore and should be left blank for
compatibility.
2.6 Creating Custom Preselection lists
The picture on the left
shows and example of
preselection list, it is shown
in red box. Creation of
preselection lists is a way of
changing how information
is shown on the display,
therefore their function is
mainly to ease the work
with RAIS to user. One
example of a good use of
Preselection List is section
2.1, where the list showed
only primary key of Facility
instead of its Name, whereas the latter would be much easier for user to interpret. To
customize this kind of display, one should:
• Open the RAIS Front end in Design Mode
• Create a new query that would contain all information that should be displayed in the
preselection window (please note that the actual value that will be displayed should be in
column nr.2, column 1 is always reserved for PK (Primary Key) values). An example of
such query is shown on the image below
• Open the Frontend in design mode and locate the source for Preselection List (Right-click
the area where list is displayed, click properties and locate the source) Remember the
name of the source table/query
• Look up the record that contains the above meant source query in table Propogator –
Menu selector and substitute the old name of the query with the newly created query
• Check the functionality