Re: Grids and SET SKIP

Believe it or not, I've never used SET SKIP. Not once. There have always
been easier ways to "get there". SET SKIP was added mostly for reporting and
it works great for that, but it carries side effects like what you're seeing
when used in a U/I.

Turn it off and let that parent table browse normally instead of with one
paw tied behind its back.

The *easy* way to do this is to put these tables in the dataenvironment, and
set the 1-to-many property of the relation to .t. -- they'll behave exactly
like what you want.

My preference would be for a parameterized local view of the child table
that's requeried as the record pointer moves through the parent.

Dan


Beverly Howard [Ms-MVP/MobileDev] wrote:
vfp7 ...yea... I know... but, the water's still pretty deep.

As my forms are getting more complex, I need some guidance on how to
handle a form with multiple related grids... the scenario;

Form displays fields from the parent dbf (works fine)

Bottom grid shows multiple rows from a related/setskip dbf (works
fine)
Top grid shows rows from the parent database and allows the user to
browse the parent...

...works, but the top grid includes lines for each of the multiple
"set skip" rows.

I assume I can address this by using the parent "again" but wonder if
there is a simpler approach to having the grid of the parent only
show a single line per parent record?

Thanks in advance,
Beverly Howard


.

Relevant Pages

  • Re: C# and many SQLDataReaders
    ... Unless your connection supports multiple readers, ... return one grid with both the parent and child data (switching parent ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: DataGrid sort
    ... Now when you change rows in your parent grid, ... change out the child grid contents and any existing child sort will be lost. ... > I had high hopes for this solution, but the child table DataGrid remains ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Re: DataGridView doesnt change with new parent record
    ... data relation between the parent and the children. ... I have a CustomersBindingSource and a Customers_OrdersBindingSource. ... The Customers_OrdersBindingSource binds to the grid with the ... now when I change the parent record (using the next and previous record ...
    (microsoft.public.dotnet.framework.windowsforms.controls)
  • Re: Force update datagrid
    ... that should work as soon as you click out of the grid ... > the new empty record of the child grid directly after typing values in the ... > new record in the parent grid. ... >>>I have a Parent and child datagrid pair. ...
    (microsoft.public.dotnet.framework.adonet)
  • Grids and SET SKIP
    ... As my forms are getting more complex, I need some guidance on how to handle a form with multiple related grids... ... Form displays fields from the parent dbf ... Top grid shows rows from the parent database and allows the user to browse the parent... ...
    (microsoft.public.fox.programmer.exchange)