At 09:28 PM 29/10/2004 +1000, you wrote:

> > 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.

Then good luck to you, Alan. I'm amazed that you can use direct
master/detail binding for many:many relationships but heck! what do I know?
(Actually, I think I'd rather not know....)

:-|

Helen