Hi,

well the method I generally use in cases like this is to do it with a
normal TIB_ComboBox.
I get the Data once and then either fill all the Comboboxes or Cache it
somewhere and fill as needed.

Then I put my surrogate key into the ItemValues and my Display Values into
Items.
Then I change the Style to csDropDownList, connect to the relevant IBO
field and I'm done.

If all the surrogate keys have the same name in the database or are always
the first field (field 0)
then it's easy to write a procedure that you just give a Dataset and a
Combobox and it extracts the
correct values automatically and put them in the Items and ItemValues for you.

Regards,

At 20:28 14.03.2001, you wrote:

>Hi,
>
>My initial problem for asking this question is that I have a table with a
>list of names and a table that uses those names for fields such as
>ReceivedBy, ApprovedBy, ForwardedTo, DecisionBy,... What I have to do now is
>set many queries (one for each field) and I though there could be a better
>way such a cloning one dataset in order to reduce the number of queries that
>need to be executed. The table, as mentionned earlier, are fairly small so
>the impact is not so bad for this case, but I was wondering what I could do
>if the table were big.
>
>Thanks
>
>----- Original Message -----
>From: "Jason Wharton" <jwharton@...>
>To: <IBObjects@yahoogroups.com>
>Sent: Wednesday, March 14, 2001 2:00 PM
>Subject: Re: [IBO] More than one Lookup combo to one dataset
>
>
> > Michael,
> >
> > There is no advantage of this over simply using a separate dataset. One
> > thing that you can do is fetch all the rows and then call
> > FreeServerResources. What this does is release the statement handle that
>the
> > dataset holds. This makes it purely a client container for rows in memory
> > from the server.
> >
> > So, consider this done...
> >
> > Jason Wharton
> > CPS - Mesa AZ
> > http://www.ibobjects.com
> >
> >
> > ----- Original Message -----
> > From: "Michael L. Horne" <guardian@...>
> > To: <IBObjects@yahoogroups.com>
> > Sent: Wednesday, March 14, 2001 9:42 AM
> > Subject: RE: [IBO] More than one Lookup combo to one dataset
> >
> >
> > > Hello
> > >
> > > What would be great for this is a new control that connects to
> > > the dataset, loads the data, disconnects, and remembers its
> > > data. Has methods to refresh, clear. And would work like
> > > the LookupCombo. This would solve the problems of multiple
> > > Datasets and would also be very useful for those small standard
> > > datasets that don't change very often, like Terms, or Warehouse
> > > .... You get the ideal. - - - - Maybe one of the genius here
> > > could write it for us?
> > >
> > > Michael L. Horne
> >
> >
> >
> >
> >
> >
> > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> >
> >
>
>
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

--
--Chris