You're blind :) It's in the paragraph at the bottom, but I will re-iterate.

Query1.KeyLinks = 'Table B.ID=Table A.Lookup1'
Query2.KeyLinks = 'Table B.ID=Table A.Lookup 2'

Will setting up a view fix it? ...and is there any plan to make IBO use the
aliases? Seems it would be a good addition to make. I certainly do
appreciate your help. I hadn't thought of making a view for that. I'm just
very used to using aliases for everything.

Sorry to be such a bother, man, but I really do appreciate your help. I
hate it when I have such a difficult time with 'little things' that should
'just work' (in my mind).

Thanks Again,

Eddie Bush

----- Original Message -----
From: Jason Wharton <jwharton@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, March 19, 2001 11:59 AM
Subject: Re: [IBO] Multiple IB_LookupCombo in TIB_Grid


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