Subject | Re: [IBO] Master-details link with a OR statement |
---|---|
Author | Helen Borrie |
Post date | 2007-07-28T22:56:42Z |
>--- In IBObjects@yahoogroups.com, "Jason Wharton" <supportlist@...>At 03:51 AM 29/07/2007, johnme199 wrote:
>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.
> >
>It works perfectly, thanksIt is similar to MasterLinks but allows you to supply the actual
>I just don't understand the masterparamlinks line ?
parameterised WHERE clause for selecting the detail records, instead
of having masterlinking routine calculate the WHERE clause itself
based on an unconditional relationship.
Helen