Dear Sir,

I have two tables master and master1.
The fields of the both tables are same as follows
sno name city country

On a form there is Grid and a command button.
Grid has following properties
thisform.grid1.recordsourcetype=1
thisform.grid1.recordsource=master1

On the click event of command1 the codes are as follows

select master1
zap
select master1
append from master for sno<10

thisform.grid1.recordsourcetype=1
thisform.grid1.recordsource=""
thisform.grid1.recordsource="master1"

after this the grid appears as a blank box.

I want to show only two fields as master1.sno and master1.name in grid.

What is wrong?

Please help me