Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ken Blum
  Where is Ken Blum?
 Chicago
 Illinois - United States
 Ken Blum
 To: Troy Reganall
  Where is Troy Reganall?
 Toledo (OH)
 Ohio - United States
 Troy Reganall
 Tags
Subject: RE: Dual Grids on a Form
Thread ID: 22592 Message ID: 22594 # Views: 21 # Ratings: 0
Version: Visual FoxPro 7 Category: Grids
Date: Tuesday, April 22, 2003 8:24:56 PM         
   


> Hello all,
>
> Ok, here is what I am trying to do. Let's say I have a form with 2 tables, 1st = Customers, 2nd = Orders. I would like to display 2 grids, 1 with a relation between Customers and Orders by something like "cust_no" and a second grid that displays all orders with no relation. Everything I have tried so far seems to only display the relation on "cust_no" in BOTH grids. Even though I have no relation set in the second grid. Anyone know how to do this?
>
> Thanks,
>
> Troy
> Long Live FoxPro!
That's because both grids are pointing to the same recordsource (Orders Table). Add another instance of the orders table in the forms dataenvironment, and have the second grdOrders.RecordSource point to that table (Orders2).

KTB

COMPLETE THREAD

Dual Grids on a Form Posted by Troy Reganall @ 4/22/2003 6:34:01 PM
RE: Dual Grids on a Form Posted by Ken Blum @ 4/22/2003 8:24:56 PM
RE: Dual Grids on a Form Posted by Troy Reganall @ 4/22/2003 8:40:19 PM
RE: Dual Grids on a Form - Works !!! Posted by Cosmin Popescu @ 4/23/2003 9:32:25 AM