Virusim,

I think I spoke to Crystal Tech Support about this issue recently and they told me I had to have both DBs in the same ODBC location such as Table1 and Table2 both had to be in the same location that the ODBC Admin was pointing to. At least that's what I remember them saying and I think I also found an article in the Crystal website knowledgebase about this too. So where I work we have taken all of our data files that are used in Crystal Reports and relocated them into one location such as C:\DATA\CRYSTAL

Best of luck.