Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Allan Cerrudo
  Where is Allan Cerrudo?
 Las Pinas City
 Philippines
 Allan Cerrudo
 To: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 Tags
Subject: RE: How to Link 2 grids by column...
Thread ID: 15859 Message ID: 15896 # Views: 0 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Thursday, October 03, 2002 5:34:06 AM         
   


>Pete,

Tried the first suggestion, but LUCK did not knock. Can't the other solution. should have only 1 column per item , total in the bottom. I already done it, using only one grid with th total in the bottom.
but If user scroll upward, user can't see the total. As per good design, I was trying to have a fix column total, wherein user may scroll up & down, still user can see the total, wherein user may scroll horizontally,
column total still match the column in grid1.

Any help from you and everybody will be very much appreciated.

Thanks again..
Allan (Cetorn Business Systems)


I have 2 grids (grid1 & grid2), each has different tables but has equal columns, each column in grid2 contains the total the counterpart column in grid1. Grid2 does not have a vertical scroll
> > bar and horizal scrollbar. I already put a procedure in the Scrolled property in grid1 using DoScroll, making the horizontabl scroll bar in grid1 and grid2 act as one.
> >
> > My problems is, if i scroll horizontally grid1 not using the horizontal scroll bar (for example using the arrow key, left to right ), the column in grid2 wont move.
> >
> >
> >
> >
>
> Hi,
> I understand what you are trying to do... but have never done it !
> Just a thought... in the lostfocus event of grid1.column1.text1 can you put
> a setfocus to grid2.column1.text1 and then back to grid1 again.
>
> And in the lostfocus event of grid1.column2.text1 can you put
> a setfocus to grid2.column2.text1 and then back to grid1 again.
>
> etc........
>
> Sounds like of clunky, but I do not know unless someone else does
> how to make the grid2 column match to the changes in the grid1 column.
> NOT EVEN SURE IF THIS WILL WORK !
>
> A possibly other solution would be to incorperate the data all within
> one grid with column1 having what-ever and column2 having the totals...etc.
> Have every second column within the grid with a different background and
> foreground colour with titles of totals on the one grid.
>
> Pete from the Great White North ! (Only in Canada, ay...) Over and Out ...


ENTIRE THREAD

How to Link 2 grids by column... Posted by Allan @ 10/2/2002 2:51:23 PM
RE: How to Link 2 grids by column... Posted by Pete Sass @ 10/2/2002 6:28:13 PM
RE: How to Link 2 grids by column... Posted by Allan @ 10/3/2002 5:34:06 AM