|Subject||Re: [IBO] Master-details link with a OR statement|
>--- In IBObjects@yahoogroups.com, "Jason Wharton" <supportlist@...>At 03:51 AM 29/07/2007, johnme199 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
> > 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.