You have created the view so far ... Do you USE it ?


>Hi all ,
>
>I create a remote view in a text lostfocus , but there nothing appeared in my listbox :
>
>
>Cser_code=this.value
>
> CREATE SQL VIEW Vuedetail REMOTE CONNECTION domino AS SELECT Rubrique.rub_code,;Rubrique.rub_libelle,Rubrique.rub_alias,;
> Rubrique.rub_etat, Rubrique.rub_touche, Typerubrique.trub_libelle ,;
> Typerubrique.trub_code;
> FROM ;
> rubrique Rubrique ;
> INNER JOIN typerubrique Typerubrique ;
> ON Rubrique.trub_code = Typerubrique.trub_code;
> WHERE Rubrique.ser_code =?Cser_code
>
>
>
> thisform.service.configuration.List1.RowSource="Vuedetail"
>
>Nb : the list1 Rowsourcetype is alias
>
>
>Best Regards