I have a variety of very large databases. One is a list of birds that can be found across North America. Another has a list of destinations around the continent. A final database is a list of sightings of birds (and other creatures).
Is there a way to be able to connect to more than one database?
Here is several scenarios.
On one form, I can access the bird species table (drop-down box with a DRW) to allow us to record a BirdID number for a species spotted on a particular outing.
On a DRW page, I need to be able to display the details of that sighting. Here's the problem. The sightings form only saved the BirdID to the sightings table. In order to be able to reconcile the BirdID with the birds common or latin name, I need to connect to the Bird Species database and build a query.
I don't mind doing some custom sql and I understand Union queries to link multiple tables, but how can I connect to queries from more than one database connection?