Browse Parent-Child help

[sukhendu]

Following example 28, I have added a button on the parent (customer) browse row.  On button click I have added a child (order) browse procedure. 

On the child browse procedure's default filter: range limit filed is ParentSysId, Range Limit Type: Table Relationship and related table is Parent (Customer).  The filter is not working.  All child records are displayed no matter which parent is selected.

This is simple parent child - but I cannot seem to set the filter correctly.  Any help is appreciated.

Sukhendu 

[kevin plummer]

Try just using a normal filter

eg 'child:ParentSysId = ' & p_web.gsv('Parent:ID') !where Parent:ID is the unique identifier on the parent table

Filters can be tricky so if you are having trouble code the filter in the embed and add a trace so you can see the value.

[Rob de Jager]

The "final" filter is set in loc:filterwas.
You can see this in the Start of "After SetView" embed in debugview if you put this code there : p_web._trace(Current filter = '  & loc:filterwas)

Cheers

Rob

[sukhendu]

Thank you Kevin and Rob.  Child filter is working now - Sukhendu