Subject Re: [IBO] Lookupcombobox question
Author Johan Kotze

I have been using IBO for a while and I am able to get the
lookupcombo to work when the "lookup dataset" has two fields: a key
field and a description field. Then I have no problems. The problem
here is that the "lookup dataset" has only one field and this is the
field that must go to the "master database". I also want to display
the field in the "master database" in a grid as well. I have tried
your enhanced lookupcombo as well, but I am sure my problem is in the
keylinks property. My Keylinks and KeyDescLinks looks like this:


Is this correct ?

Johan Kotze

--- In IBObjects@y..., "Geoff Worboys" <geoff@t...> wrote:
> > I have a table called "stock" that contains a field "Model".
> > I have another table called "Models" that contains a list of
> > valid models. How do I setup a lookupcombobox to display a
> > dropdown list from the "Models" table and update the "model"
> > field in the "stock" table. The field to display in the
> > dropdown box is "Modelname" and this is also the value to
> > update the stock table with.
> Sounds like you are just getting started? Take a look at the
> tutorial/sample applications that come with IBO. There is also a
> "Getting Started Guide" available for purchase from the ibobjects
> website which I believe provides detailed explanation of the steps
> involved.
> The main thing to remember is that TIB_LookupCombo does not quite
> like other controls...
> TIB_LookupCombo connects to the "lookup dataset". It does NOT
> to the main dataset that you are editing. The TIB_LookupCombo
> provides a selection capability to lookup records in the lookup
> dataset.
> The "lookup dataset" is simply a normal TIB_Query except that you
> define the KeySource property to point the main datasource (where
> wish edit the foreign key value). It is the lookup dataset that
> the main dataset field - via the specially defined KeyLinks. The
> lookupcombo is simply used to move the lookup dataset row selection.
> Hopefully this will give a start to understanding the examples a
> little better.
> Geoff Worboys
> Telesis Computing