I think you will need to define a view for the lookup table so that it can
be distinguished but the table name. KeyLinks does not support using the
table alias name.

Either I am blind or you haven't shown exactly what your KeyLinks property
is setup as. I'm sure that would help to know this.

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

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


> 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/
> >
> >
> >
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>