What should I defined as the KeyLink in the following SQL :

select v.cliente, cli.nome, sum(p.qtde) as totqtde
from vendas v
join prodnota p on p.id_num = v.id_num
join clientes cli on cli.codcli = v.cliente
where (p.codprod = :codprod) and (v.emissao between :dia1 and :dia2)
group by v.cliente, cli.nome

When I try to define it as vendas.cliente I get a "Invalid KeyLinks".
Should I leave KeyLinksAutoDefine=true ?

[]s

Carlos
WarmBoot Informatica - http://www.warmboot.com.br
Interbase-BR - http://www.interbase-br.com