Your CursorSchema needs to include all the fields that are being SELECTED from both tables. You are selecting ST.* from the A_Statut table. Since this is probably not the only field in that table, you either have to add all the other fields to the CursorSchema or modify you SelectCmd to SELECT DP.*, ST.StCode FROM...

>Hi all
>I've used the Cabuilder from Mark McCasLand to create my CursorAdapaters, and it working fine.
>
>In the DE of a Form I Add the CA a_dependants and replace the SelectCmd with this:
>SELECT DP.*,ST.* from A_Dependants as DP (Nolock) left join A_statut as ST (nolock) on (st.Id_statut = dp.destatus)
>
>The CursorShema look like this :
>ID_DEPENDANTS I,ID_MEMBRES I,DENOM C(20),DEPRENOM C(20),DENATURE N(3,0),
>DEDATENAISSANCE D,DATEDEBUT D,DATEFIN D,DEREMARQUE M,DESTATUS I,DESEXE N(3,0),STCODE C (6)
>the STCODE field come from the a_statut table
>
>
>Next I put a grid on the form with all the fileds from the CA a_dependants then I run it.
>It work fine but i want the sql date to be like vfp date and not date time like..
>
>If I put the lusecursorshema to .T.
>I got this message :
>Error loading file-record number 8.Grddependants or one of its members. ControlSourc: a_dependants is not found.
>
>The CA a_dependants is not create. Why ?
>
>Any idea's
>
>Thank you