Subject Re: [IBO] lookup-combo
Author admforum

Thank you very much. I forgot the most basic property of them
all..... KeySource!!!! Stupid. IBO, and the number of properties,
can, however, be overwelming for beginning users

Thanks for pointing that out to me.


--- In IBObjects@y..., "Helen Borrie (TeamIBO)" <helebor@d...> wrote:
> At 10:04 AM 11-02-02 +0000, Remco wrote:
> >Hi,
> >
> >I just spend this whole morning (CET) trying to figure out why a
> >lookupcombo doesn't seem to work.
> >
> >I've used it before and it worked flawlessly.
> >
> >This time the combobox gets filled up with the values of the
> >qry (so that's OK). But if I walk through the 'main' dataset, the
> >lookup-combo keeps displaying the same value (it should change
> >according to the values in the main dataset) and if I
> >the main dataset the color of the lookup-combo doesn't change
> >(colorscheme property is TRUE)and changing the value of the combo
> >doesn't alter the FK column of the main dataset.
> Have you set the Keysource and KeyLinks properties? (remember,
dual keylinks in lookup datasets...)
> If you have a FK relationship from the main dataset, pointing to
the PK of the lookup dataset, do these two columns match for datatype?
> Is this FK in the main dataset being used for any other
relationship, e.g. a join? If so, are the keylinks of the main
dataset 100% unique?
> If the main dataset is a single table, what kind of primary key
does it have? Is it, for example, a composite involving the FK that
points to the lookup set?
> Are you using KeyDescLinks at all?
> Are you using JoinLinks at all?
> fwiw, I didn't know that the ColorScheme property would transfer to
the lookupcombo, since the lookupcombo itself doesn't go into dssEdit
or dssInsert...did it happen that way for you before?
> >Please, give me some hints :-)
> hth
> regards,
> Helen Borrie (TeamIBO Support)
> ** Please don't email your support questions privately **
> Ask on the list and everyone benefits
> Don't forget the IB Objects online FAQ - link from any page at