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