Datasheet

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization
44
Please note that SQL statements shall always return search result in the form Primary Key,
Name. Also note that the field Search SQL may contain either an SQL statement or a named
query.
Search Item Facility
Search Filed Name
Search SQL Facility Name Search List
Result Menu INPUT
Result Form SUB EDIT Facility
where the query named [Facility Name Search List] would contain the statement
select [PK Facility ID], [Facility Name] from [Facility] where [Facility Name] like "*" &
[Value] & "*" order by [Facility Name]
2.13 Multiple selection (junction forms)
The lists on the junction forms are fed by “Unallocation” and “Allocation” queries for the left
hand side and right hand side list respectively (see the picture below). Those queries and
forms are easily created with the Creator (selecting “Multiple lookup” field when creating
new field on a form).
The general approach for customization applies also to multiple selection form queries:
The best approach for creating new custom forms is:
Lookup in OnDblClick Event
Allocation – query
Unallocation – query
query
Field Name