Subject RE: [IBO] IB_Query/SP/KeyLinks
Author Alan McDonald
> SELECT FIELD1, FIELD2, FIELD3 FROM LOAN_S_ALL(:FIELD3)
> KeyLinks property set to 'FIELD1'
> and the MasterParamLinks set to 'FIELD3=Mast.FIELD3'
> where "Mast" is the name of the table that has FIELD3 either as
> its primary
> key or as another unique key.
>
> Helen

sorry for making this sound like a can of worms but
FIELD3 is sourced from a table which does not have it as it's PK OR as a
unique key. I've never been forced to have the master source have a unique
presence in the master dataset. As it scrolls (the master) the detail should
always be refreshed on that master source no matter how many times it
appears in the master source. and the master source can be order in any
fashion too - it the masterlink is found again - there's no problem there
either.
Alan