For clarification, here is what the tables look like:

Table A:

ID Integer
Lookup1 Integer
Qty1 Integer
Lookup2 Integer
Qty2 Integer

Table B:

ID Integer
Name VarChar(25)

What I am trying to do is use Table B as a lookup table, where Table B.Name
would be shown in place of Table A.Lookup1 and Table A.Lookup2. My query
that pulls back Table A's data looks like this:

Select ID
, Lookup1
, L1.Name as Lookup1Name
, Qty1
, Lookup2
, L2.Name as Lookup2Name
, Qty2
From Table A
Join Table B L1
On (Table A.Lookup1=Table B.ID)
Join Table B L2
On (Table A.Lookup2=Table B.ID)
For Update

Of course, I hide the Lookup fields in the query, and join on the lookup to
get the actual text values (meaningful values for the user). I have two
IB_LookupCombo components on a TIB_Grid, and I have three querries and
datasources -- all dedicated to this one thing. One query/datasource is for
modifying Table A, and the other two querries/datasources are for use with
the two TIB_LookupCombo components. The only difference between the two
querries is that the keylinks is different. One of them says Table
B.ID=TableA.Lookup1, and the other says Table B.ID=Table A.Lookup 2.

Thank you for your assistance!!

Eddie

----- Original Message -----
From: Eddie Bush <eddie@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, March 19, 2001 1:25 PM
Subject: Re: [IBO] Multiple IB_LookupCombo in TIB_Grid


> Does this have something to do with both fields in the keysource table
being
> the same? ...because it looks like the second field's lookup combo is
> showing up where the one for the first field should be if I remove the
first
> one.
>
> How do I make this work, please?!? I really think I'm doing everything
just
> fine, but it simply does not work!
>
> Thanks Much!
>
> Eddie Bush
>
>
> ----- Original Message -----
> From: Eddie Bush <eddie@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Monday, March 19, 2001 1:03 PM
> Subject: [IBO] Multiple IB_LookupCombo in TIB_Grid
>
>
> > Hello people!
> >
> > I have a grid that has two fields that use the same lookup table. I'd
> like to use a lookup combo for both fields, but when I run the application
> only the first one works. I did set the keylinks up correctly, I believe.
> Is there something else that needs to be done? The first one works
> correctly.
> >
> > Thanks Much!
> >
> > Eddie Bush
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> > 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/
>
>
>