In my sample I used the SFLIGHT table with its key fields on screen: carrid, connid and fldate. For displaying the available flights there will be a serach help for each key field in order to select a single value for each of them. After selecting each value there must be a restriction for the other key fields. For example, if we choose airline ‘AA’, then we must have only the connections available for ‘AA’ for the connections SH.
For the OnInputprocessing event of start.htm we´ll have the following procedure:
In the sh.htm page we´ll need to develop the OnInitialization event to load the values for the tables: scarr, spfli and sflight. Then create the following layout considering which table to display according to the parameter passed through the URL. Remember to create the page attribute p_column_definitions as the type T_COLUMN_DEFINITIONS for each table.
To get each table view value place the following code in the OnInputProcessing event of sh.htm for each table according to the search help requested in start.htm. Remember to restrict the select statement for the connection and the flight date according to the parameters of the URL.
Follows the prints for the solution: