>
>How can I insert the field modalidade_id in table Atividades? It doesn't
>exist in my selectSQL. I only have the loockup field modalidade.

If the field atividades.modalidade_id may be changed in your application,
then you need to include it in the dataset. You do not need to display it
in the grid - simply set its FieldsVisible attribute to False.
-----------------
In the example of the Configuring ib_loockucombo, the field isn't in the
table. Ex:
select
NAME,
(select DESCRIPTION from PRODUCETYPE T
where T.TYPE = P.TYPE) as TYPE_DESC,
DESCRIPTION,
PRICE,
QTY
from PRODUCE P

Then is just so? Is not necessary to put the TYPE_DESC in any insertSQL or
updateSQL..
------------------

>To insert and update the fields using the IB_QUERY or IBOQUERY I must set
>the insertSQL and updateSQL ?

No - IBO will do this automatically. Custom SQL - which is a statement in
the relevant xxxxxSQL property - is not needed unless, for example, you
want to call a stored procedure INSTEAD of IBO's conventional update
behaviour.