At 07:07 AM 24-08-01 +0000, you wrote:

>is it possible to let KeySource and Mastersource of a TIB_Query
>(4.2Eb) point at the same datasource?
>I want a TIB_LookupCombo for selection out of the middle table of a m
>to n relation. One field of the edited table should make the
>selection of the set as master source, the other the only selected
>record as keysource. (I hope my discription is not too confusing)
>
>When I do this in that manner i get the
>error 'E_Multiple_Rows_In_Singleton' out of
>TIB_BindingCursor.QuickFetch.

You will need two separate data sets, one to make a KeyLinks connection and point to the Keysource, the other to make a MasterLinks connection and point to the MasterSource.

To avoid the "multiple rows..." error, make sure that each row in the set that you are using for the lookup table in the Keylinks relationship is unique, i.e. the lookup key in the Keysource must find one and only one row in the lookup dataset.

rgds,
Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________