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