Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Khurram Tahir
  Where is Khurram Tahir?
 Karachi
 Pakistan
 Khurram Tahir
 To: tushar Kanvinde
  Where is tushar Kanvinde?
 Kolhapur, Maharastra
 India
 tushar Kanvinde
 Tags
Subject: RE: Parent,child & Txtsearchgrid1 control
Thread ID: 288731 Message ID: 288800 # Views: 27 # Ratings: 0
Version: Visual FoxPro 9 Category: Projects and Design
Date: Friday, December 24, 2010 8:12:31 AM         
   


> > Q. Using Txtsearchgrid1 control designed by Marcia Akins for incremental searching in grid it is working okay but in Parent child senario how it works
> >
> > I have two grids 1 for parent table and 2nd for child table
> >
> > Parent Table Index on Key_Pk
> >
> > Child Table Indxex on Key_Fk
> >
> > Select Parent
> >
> > Set Relation to Key_Pk into Child
> >
> >
WITH Thisform.Grid2
> > 
> > 	.COLUMN3.Txtsearchgrid1.Init() && Sn
> > 	.COLUMN7.Txtsearchgrid1.Init() && Item No
> > 	.COLUMN8.Txtsearchgrid1.Init() && Part No
> > 	.COLUMN9.Txtsearchgrid1.Init() && Desc
> > 	
> > ENDWITH

> >
> > Q. But when i press in column3 of grid of child table e.g. 2 or 3 it goes on top of child table instead of going on 2 or 3 Why same thing happening on other columns too with txtsearchgrid1 ?
> >
> >
> >
> >
> >
>
> Init is an event that is supposed to happen. It is not supposed to be called like that. I think the grid search class can change the order of the child. Which will create problems for your relationship. It should be better to use a cursor instead for the child grid.
>
> Regards
> Tushar

I already created cursor for Parent & Child table then relate the Cursors and then using txtsearchgrid control and all this happening.

ENTIRE THREAD

Parent,child & Txtsearchgrid1 control Posted by Khurram Tahir @ 12/23/2010 2:30:28 PM
RE: Parent,child & Txtsearchgrid1 control Posted by tushar @ 12/24/2010 7:13:15 AM
RE: Parent,child & Txtsearchgrid1 control Posted by Khurram Tahir @ 12/24/2010 8:12:31 AM
RE: Parent,child & Txtsearchgrid1 control Posted by tushar @ 12/24/2010 8:17:33 AM
RE: Parent,child & Txtsearchgrid1 control Posted by Rajesh Malhotra @ 12/24/2010 9:04:40 AM
RE: Parent,child & Txtsearchgrid1 control Posted by Khurram Tahir @ 12/25/2010 3:31:14 PM