Hi Nick

Sorry too many questions, but is the first time i doing this, i try your code like bellow, and

create sql view myView1 as select forart.c_codigo,forart.c_sartigo,fornecedores.c_descri ;
from forart ;
left outer join fornecedores ;
on fornecedores.c_codigo=forart.c_codigo;
where forart.c_artigo=thisform.text1.value

select myView1-I get an error Alias not found and i have view rcorsource=1-Alias

requery()

Thank's in Advance

Joao