1.what you mean (form's DE ),any sample ,

Data Environment


2.i have two tables with same fields, i use table4 as temperory file,

You can accomplish the same thing using a CURSOR as the grid's RecordSource. Just create the cursor in the form's Load() using the CREATE CURSOR command (details are in the on-line help). Then, when you need to change the contents of the cursor, you use code like this:

*** Rebuild the cursor used as the recordSource for the grid
*** This assumes that table4 is a cursor created in the form's
*** load using CREATE CURSOR
SELECT Yada, Nada, Blah FROM SomeTable WHERE SomeCondition INTO CURSOR Temp NOFILTER
SELECT Table4
ZAP
APPEND FROM DBF( 'Temp' )
USE IN Temp
GO TOP IN Table4
Thisform.MyGrid.Refresh()