Actually, where there are two separate datasets it shouldn't require a view.
Just don't use table aliases and you should be fine.

I would rather not support table aliases because it is too complex to parse
it all out and such luxury would come at too much of a performance price. If
the view work around didn't exist I would do it but since a view is all you
need I don't bother.

Don't put single quotes in the keylinks property.

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

----- 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/
>
>