Define return prompts to create default values for specific prompts. For example, if creating an inter-warehouse transfer issue with a prompt for requisition number, requisition line, and outstanding quantity, set up a trigger to search and automatically populate outstanding quantity with a value. Define triggers using SQL statements defined on the Select statement definition form (BMQUER).
Follow these steps to define return transaction prompts.
Open the Data collection tracking prompts form (TMASTP).
Query for the transaction type for which to define return prompts.
Click the Return prompts tab. Datastream 7i displays the Return prompts page.
Source prompt—Click to select the number corresponding to the prompt sequence number that triggers the return prompt when you leave or tab out of the field.
Target prompt—Enter the number corresponding to the target prompt sequence number that receives the default value.
SQL code—Click to select the code identifying the SQL statement that calculates the default value for the target prompt.
Click the Record view tab. Datastream 7i displays the Record view page.
Click Validate to verify that all source prompts and target prompts exist for the transaction and that target prompts are referred to only once.
Choose File | Save from the menu bar. Datastream 7i saves the information to the database.