integer rtncode
rtncode = dw_1.GetChild(' emp_state', state_child)
IF rtncode = -1 THEN MessageBox("Error", "Not a DataWindowChild")
// Establish the connection if not already connected
CONNECT USING SQLCA;
// Set the transaction object for the child
state_child.SetTransObject(SQLCA)
// Populate the child with values for eastern states
state_child.Retrieve()
// Set transaction object for main DW and retrieve
dw_1.SetTransObject(SQLCA)
dw_1.Retrieve()