I have two grids on my form. One of the field is a listbox having a valid event that based on a certain condition need to add a record in the second grid.
In my valid event code, I change to my second grid alias before doing the APPEND BLANK. The problem is that even if I switch alias, because I am in a grid, the alias changes back to the first grid which forces the APPEND BLANK to add in the first grid instead of the 2nd.
Here's a sample of the code in my valid event of the listbox of the first grid.
IF condition...
SELECT alias of grid 2
APPEND BLANK
REPLACE ...
ENDIF
The SELECT alias of grid 2 works but before the APPEND BLANK can be executed, the alias is switched back to the alias of the first grid.
Is there a workaround for that?