The values stored in a cache variable can be displayed in any label, literal, textbox or dropdown list control using the CACHE function.
Step 1: In the Layout Editor, select a table control.
Step 2: In the Property Sheet, Queries section, select the appropriate query and open the Query Wizard (Edit…).
Step 3: In the Query Wizard, add a new WHERE clause containing a formula that restricts the contents. For example, to display the contents related to the most recently placed order, specify a formula in the Query Wizard, e.g.:
= CACHE(“OrderID”)
Step 4: Build and run the application.