Subject Re: [IBO] Master-details link with a OR statement
Author Helen Borrie
>--- In IBObjects@yahoogroups.com, "Jason Wharton" <supportlist@...>
>wrote:
>
> > Make this your WHERE clause:
> >
> > WHERE (( NOIDTABLE1A = :TABLE1.NOIDTABLE1 ) OR
> > ( NOIDTABLE1B = :TABLE1.NOIDTABLE1 ))
> >
> > Make MasterLinks property blank.
> >
> > Put this in MasterParamLinks:
> >
> > TABLE1.NOIDTABLE1=TABLE1.NOIDTABLE1
> >
> > Make sure the MasterSource property points to the DataSource of
>the master
> > dataset.
> >
> > This should work just dandy.
> >

At 03:51 AM 29/07/2007, johnme199 wrote:
>It works perfectly, thanks
>I just don't understand the masterparamlinks line ?

It is similar to MasterLinks but allows you to supply the actual
parameterised WHERE clause for selecting the detail records, instead
of having masterlinking routine calculate the WHERE clause itself
based on an unconditional relationship.

Helen