Hi Gaetano,

I'm not sure why do you need two CAs of the same table that also reference each other. Can you clarify?

>
>I need a little help about a "where clause".
>In a form I use only one SQL table, i.e named cTable.
>
>I have created two CA,i.e named caTable1 and caTable2, with the same Select like this:
>Select cTable.code, cTable.descr, cTable.perc1, cTable.perc2, cTable.appcode from cTable
>
>The cursor caTable2 is used in the form in order to create a PickList for Field appcode in cTable.
>
>I need to create in the caTable2 a "where" clause that satisfy these rules when appcode in the Form is not null:
>1) The perc1 in the caTable2 must be equal to perc1 in caTable1
>2) the perc2 in the catable1 must be equal to ZERO.
>
>I am a neophite in VFP with SQL, and I hope in your help in order to resolve this question.
>
>Thank you and Best Regards.