Hi Vinod.
>
>Currently I created 2 views, 1 parent and 1 child... But the problems I'm facing are :-
>
>1. When I move the record pointer in parent view, child view's grid is not updating...
>2. Its written in documentation that its not right to create indexes on view, then how i should relate my 2 views....
>
The way that I would handle it is to create the child view as a parameterized view. To do this, you specify something like WHERE (childTable.FoeignKey) = ?nParentyKeyValue as your filter expression. Then, in the AfterRowColChange of the grid that displays the parent table, you set the value of nParentKeyValue and REQUERY the child view.
BTW, you can create temporary indexes on views. You just have to be sure that the view is available and row buffered when you do this.
Marcia
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only