> 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