Datasheet

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization
22
Field Name FK Region ID
Parameter Name Region ID
Parent Not used any more
This simply makes the value of the control [Region ID] (located in the main input form) be
propagated into the field [FK Region ID] of a new facility.
2.4.1.2 Propagating Visual Basic expressions
In this example, we automatically set the current date to be the default date when entering
new historical records for workers. Add the following record to the table [Propagator –
Preselection]
Form Name SUB EDIT Person History
Field Name Status Date
Parameter Name =Now()
Parent
Now open the RAIS Interface and add a new worker history. You will notice that the current
date is automatically inserted into the status date field. Note that you may overwrite this
default value. Also note that you may use any Visual Basic expression that evaluates to a
simple type (string or value).
2.4.1.3 Propagating primary keys
RAIS 3.0 has a very extensive concept of history records. Generators have historical records,
allowing for tracing the status of generators at any moment in time. When we want to enter a
new historical record, we first have to select the generator, switch to its history, and then only
we may add a new historical record. It is clear that this new history record must be bound to
the generator we have selected, in other words the primary key of the generator must be
propagated into the new historical record. This is achieved by the following entry in the table
[Propagator – Foreign Keys]
Form Name SUB EDIT Generator History
Field Name FK Generator ID
Parameter Name Parameter 0
Parent
Please note especially the field [Parameter Name]. The primary key of each information item
we select is always copied into the control [Parameter 0] of the main input form. This may be
considered as a general identifier. The field Parent is not used any more and should be left
blank for compatibility.
2.5 Creating Custom combo box contents
The RAIS Interface contains lots of combo boxes in input forms, offering for example
selecting generator models or equipment status. Microsoft Access allows these combo boxes
to be filled by results of queries, referred to as entry filters. This feature is used by RAIS
through the table [Propagator – Preselection Filters]
Add something on custom list boxes very similar to combo boxes