Not quite the same issue I've had in the past because I don't use CA's - but what I've done before is create remote views, then create a local view to join the remote views - this way you can be hitting multiple data-sources.
>I believe I tried not long ago to create a view that joined a table in the DBC to one that was not in the DBC. Is there a way to do this? IIRC, VFP was not allowing me to do this. My situation is that I need to join two tables in my DBC to a cursor created via a CA that originates from a Firebird database. I was thinking maybe I could do it all with a CA, but a CA makes you select your datasource type and you can't select two (native and ODBC). Perhaps if the native tables are already open, it will "just work." I only have to update one of the native VFP tables, so that part is not very demanding. Has anyone done something like this before?
>
>Thanks,
>
>Russell Campbell
ICQ 10556 (ya), 254117