Re: DataView.RowFilter

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Magne Ryholt (magne.ryholt_at_bluezone.no)
Date: 08/04/04 

Date: Wed, 4 Aug 2004 10:27:14 +0200

That will work, but is there really no way of accessing directly in the
filter ? (seems a bit starnge if not possible since Parent.Name works fine)

"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:O2AUKsfeEHA.2804@TK2MSFTNGP11.phx.gbl...
> Hi Magne,
>
> One way would be to create an expression column in each child with parent
> value.
> That will give you grandparent or whatever value you want.
>
> --
> Miha Markic [MVP C#] - RightHand .NET consulting & development
> miha at rthand com
> www.rthand.com
>
> "Magne Ryholt" <magne.ryholt@bluezone.no> wrote in message
> news:Oy83jmfeEHA.3412@TK2MSFTNGP11.phx.gbl...
> > I need to filter a view on values from parent table, this works fine
e.g.
> > "Parent.Name='MyFathersName'"
> >
> > However, I also need to filter on grandparent and grand-grand parents
> > (a.s.o.) columns as well, syntax
"Parent.Parent.Name='MyGrandFathersName'"
> > does not work (exception is thrown), any one knows how to do this ?
> >
> >
> >
>
>
>

Relevant Pages

  • RE: combo box, select all
    ... 'Remove the form's filter. ... Assuming the latter you need to requery the subform ... the parent form's Controls collection which houses the subform, ... Select the button in form design view and open its properties sheet if its ...
    (microsoft.public.access.gettingstarted)
  • Child Aggregate Filter Not Recognising Newly Added Child Rows (ADO.NET 2.0 Dataset)
    ... reflect in any aggregate filter placed upon the parent table. ... Public Sub FillParent() ... (i.e. the filter does not recognise the new child rows). ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: select record based on record selected in the child form
    ... The Parent form and subform use the same table as the record source. ... the child records reset and the pointer was no ... 'THIS PORTION OF CODE WORKS TO FILTER THE PARENT FORM ... frmInvoice has subform frmInvoiceLineAddSubform based on ...
    (microsoft.public.access.formscoding)
  • Re: select record based on record selected in the child form
    ... The Parent form and subform use the same table as the record source. ... the child records reset and the pointer was no ... 'THIS PORTION OF CODE WORKS TO FILTER THE PARENT FORM ... frmInvoice has subform frmInvoiceLineAddSubform based on ...
    (microsoft.public.access.formscoding)
  • Re: Filtering and Parent-Child Relation
    ... I had one filter that on a Parent Table that the filter was depending ... on the Child of that table. ... and a child table called AccountRoutes with also 2 columns AccountID ...
    (microsoft.public.sqlserver.replication)