I want to use a LookupCombo in a different way when embedded in a Grid.

My KeySource SQL is like:
SELECT ID
, (SELECT DESCRIPTION
FROM LOOKUPTABLE
WHERE LOOKUPTABLE.ID = KEYSOURCETABLE.ID)
AS LOOKUPTABLE_DESCRIPTION
, ...
FROM KEYSOURCETABLE

And my LookUp SQL is like:
SELECT ID, DESCRIPTION
FROM LOOKUPTABLE

When I'm using the LookupCombo bounded to the Description field, all works
fine.

But I'm intending to bind the LookupCombo to the ID field, so in the Grid
I'd see the ID (bounded with the Lookup) and at its side the Description (a
computed field).

Can it be done?

Thanks in advance.

---------------------------
Martin D. Berezaga
mdberezaga@...
ICQ : 18537142
Porto Alegre - RS - Brasil
---------------------------

_______________________________________________________________________
Yahoo! GeoCities
Tudo para criar o seu site: ferramentas f�ceis de usar, espa�o de sobra e acess�rios.
http://br.geocities.yahoo.com/