>Vinod,
>
>select ParentView
>skip 1
>Requery( "ChildView" )
>thisform.Refresh()
>
>Filters cause grids to perform very slowly. The view should be able to do all the work. Basically at the same place you SET FILTER you'd do Requery() instead.
>
>>Currently I've solved the problem by creating a filter in Grid's view...
>>
>>But its really strange that even when I'm browsing the records through data window, record pointer is not moving at all...
>>
>>Child view is returning me all the records which are matching but if i move the pointer in parent view, child view's pointer is still there on the old record..

Pls help me on this.. I'm still not able to get the desired result and using filter as a temporary solution..

Below is given sql command which view is generating... Pls advs. if anything is wrong in that..

SELECT Imlc.*;
FROM im!banksview INNER JOIN im!imlc ;
ON Banksview.bnk_pk = Imlc.lc_bnkfk


Imlc is a child table holds LC Info.
Banksview is a view from main table which is Imbanks holds bank names

Banksview.bnk_PrimaryKey is equal to Imlc.lc_bnk's Foregin Key.