thx for reply!
The currently result is the grid only display the whole "sodetail " table, as i want to display the "sodetail" with it field's "so_no" which is equal to "sono".

i place the coding at the form (the form that contain the grid) .init. As i think it's not the problem of the coding position. Also, i vh already checked the value contain inside "sono", and it's right and contain what i nedded!

Also , i want to ask another question that, if i display the table on the grid, the column header is what the fields name, how can i change the display column name into a meaningful name?!

THX Again~~