Profound Logic Forums

I am trying add a subfile grid to my display file with the grid being populated based on values on the screen. In the grid "selection criteria" property I have the following code:

js:"BCHTYB='" + get('BCHTYB') + "' AND USRPFB = '" + get('USRPF#') + "'";

On the screen, I have fields with ids of BCHTYB and USRPF#.

When I look at the requests being sent to the server for PUI0009102 the values from the get functions are blanks instead of the values on the screen. Am I doing something wrong?

Also, I am seeing 3 requests (with the same sql) being made to PUI0009102 each time the screen is displayed. If I change the gets to hardcoded values in the above code, the grid loads but flashes as the data from the 3 requests are processed.

You will need to bind a 100A field to the section criteria property and populate it with RPG