Table names seem to have a blank in the middle. Could it be the problem?

Also, lookups are done with an inner select for the human readable value of
the lookup, not with a join. I didn't understand the whole idea in the
excerpt posted.

C.

> -----Original Message-----
> From: Jason Wharton [mailto:jwharton@...]
> Sent: Lunes 19 de Marzo de 2001 17:22
>
> Don't put single quotes in the keylinks property.
>
> ----- Original Message -----
> From: "Eddie Bush" <eddie@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Monday, March 19, 2001 3:54 PM
> Subject: Re: [IBO] Multiple IB_LookupCombo in TIB_Grid
>
>
> > 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/
> > >
> > >
> > >
> >
> >
> >
> >
> >
> > 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/
>
>
>