I tried to see this fail and I could not.
Will you please send me an example of this not working due to the space?

Jason Wharton

> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> Behalf Of Terry
> Sent: Wednesday, May 03, 2006 6:49 AM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Lookup Combo in TIB_Grid
>
>
> > >Here's what I have. I have two main tables, EMPLOYEES and
> EMP_CODES,
> > >and seven lookup tables which are all linked to EMP_CODES.
> > >
> > >EMPLOYEES.KeyLinks: "EMPLOYEES.ID"
> > >
> > >EMP_CODES.KeyLinks: "EMP_CODES.ID"
> > >EMP_CODES.MasterSource: EMPLOYEES
> > >EMP_CODES.MasterLinks: "EMP_CODES.EMP_NO = EMPLOYEES.EMP_NO"
> > >
> > >EMP_CODES SQL includes the inline selects for the lookup fields
> > >
> > >LOOKUPS.KeyLinks: "LOOKUP.ID = EMP_CODES.LOOKUP_ID" (primary
> key,foreign key)
> > >LOOKUPS.KeyDescLinks: "LOOKUP.NAME = LOOKUP_NAME" (as designated in
> > >the inline selects in EMP_CODES SQL)
> >
> > OK, but make sure that there are no spaces around the "=" signs.
>
> That was the problem. It's kind of strange, since the spaces didn't
> break anything else until I tried to use the LookupCombo in the grid.
> All the other MasterLinks and KeyLinks associations worked perfectly
> except that one, even with the spaces around the '='. When I removed
> the spaces, it embedded the LookupCombo just like it should.
>
> Thanks a bunch for your help, Helen!