I’m trying to create a tree view of nested grids. There will be 4 levels down from the main table like a cascading effect using the + button to expand. I’ve read the explanation of Nested Grids in the Help/User Manual, and the first issue I have is how to create the necessary parameters.
Here is what the manual says: (To use a grid as a nested grid is required that the nested application uses at least
one parameter or global variable in its SQL statement as on the picture bellow.).
When I try to create the link and select from the Applications List, SC never gives me the screens/options to set up parameters. It simply defaults to Create Without Parameters.
I don’t see how to define and set the parameters. What I have is an ID field on the main table(s) that will match the same field in the subsidiary table(s) so basically would be master_id in master table = master_id in subsidiary table as you would have in a where clause. Except, it seems like maybe a global variable needs already to be established.
I can’t figure out how to establish the global variable or the parameter such that I can use in the Nested Grid.
Could someone provide the steps necessary?