Hi!

I´m trying to use the component TIBQuery and make a join with a
table. Here is the tables:

TABLE FABRICANTE:
CD_FABRICANTE SMALLINT NOT NULL,
NM_FABRICANTE VARCHAR(30) NOT NULL

TABLE ANTENA:
CD_ANTENA SMALLINT NOT NULL,
ID_FABRICANTE SMALLINT,
DESCRICAO VARCHAR(40) NOT NULL,
GANHO FLOAT NOT NULL

I´m using the folowing SQL to do this:

SELECT FABRICANTE.NM_FABRICANTE, ANTENA.CD_ANTENA, ANTENA.DESCRICAO,
ANTENA.GANHO
FROM ANTENA
LEFT OUTER JOIN FABRICANTE ON (ANTENA.ID_FABRICANTE =
FABRICANTE.CD_FABRICANTE)

The question is: How can I do a query which gives me the ability to
edit that join? I want to simulate a LookupField in table ANTENA
(FABRICANTE.NM_FABRICANTE). I dont know if you understand... I just
want to edit the values (NM_FABRICANTE) of the above query, using the
TIB_Query. Is that possible or I have to use the TIBOTable to do that
(just like the TTable) ?

Thank you very much!

Marco André