I'm hoping to use Crystal 8.5 to query two separate sql server databases. The structure, table and field names are common, but they are located on different sites. We have the infrastructre in place to communicate, but I have concerns about distingushing between databases whilst deep in authoring!

I believe I can utilise aliases to distinguish tables, but i have concerns about the ODBC connection, datatransfer rates and any nasty suprises that lay ahead!

Any experience you may have would be gratefully received.