Chapter 12. Detail Windows and Task Panes
We can use another technique to show details in windows and task panes using the SelectionChange handlers.
Let's select the handlers worksheet and add the SelectionChange handler:
Switch to the payments worksheet and click Reload, Reload Data and Configuration to reload the configuration.
Then select another row in the Payments table. You will see the window with row details:
You can select another row. The window will stay on top and show related information.
You can transpose row to columns in the output window. Just add the _Transpose word in TARGET_WORSHEET:
Switch to the payments worksheet and click Reload, Reload Data and Configuration. A new window looks like
Use of detail windows is a good solution when you need windows that are always visible.
If you need context windows, you can use task panes. Just add the _TaskPane word in TARGET_WORSHEET:
A new task pane window will look like
You can customize column formats using the context menu.
Also, you can dock task panes and turn them on/off using the SaveToDB, Options, Show Task Panes option.