Did you specify different names for alias property for your CAs ?

Also, completely forgot - you need to call CA.CursorFill() method in form's Load.

>>>I am updating my application with mysql backend . I have used my dbf tables in DE . Now i am trying to create CA with same name. I have problem in my some forms which have more than one CA. CA adapter is in the DE but when i load the form and check the data session, there is no table.(if i have two ca. only one table is in the datasession)
>>
>>Can you post some of the code in these CAs and form's Load?
>
>

>Auto open CA:
>
>*** Setup code: DO NOT REMOVE
>if not pemstatus(This, '__VFPSetup', 5)
>	This.AddProperty('__VFPSetup', 1)
>	This.Init()
>endif
>*** End of Setup code: DO NOT REMOVE
>ini:
>
>*** Setup code: DO NOT REMOVE
>local llReturn
>do case
>	case not pemstatus(This, '__VFPSetup', 5)
>		This.AddProperty('__VFPSetup', 0)
>	case This.__VFPSetup = 1
>		This.__VFPSetup = 2
>	case This.__VFPSetup = 2
>		This.__VFPSetup = 0
>		return
>endcase
>set multilocks on
>llReturn = dodefault()
>*** End of Setup code: DO NOT REMOVE
>
>*** Setup code: DO NOT REMOVE
>if This.__VFPSetup = 1
>	This.__VFPSetup = 2
>endif
>return llReturn
>*** End of Setup code: DO NOT REMOVE
>

>
>I have nothing in load. because i am only trying if my cursor Adapter is working.