Access mutiple SQL databases?

[deandog]

I have an idea how to proceed on a project, but need some input before I plunge into it.

Is it possible (I've never done any work with SQL databases) to have one AMS screen access similar data from multiple databases simultaneously?

A simple sample is as follows:
Database 1 contains details about songs, albums and artists
Database 2 contains details about movies
Database 3 contains details about TV productions

If I select a performer from a drop-down list, can I read data from these three databases and show the results together on screen? For example, if I choose an artist, I need to know what albums, TV shows and movies they've been in?

As well, if I only wanted to search about music and TV programs, would I use check boxes to filter the data reported back from the databases or can it be configured to only search the "chosen" databases?

Thanks,
Dean

[Dermot]

You can use multiple databases at one time, but what you describe would only require one database with a separate table for each type, music, movies, tv.

[deandog]

D'OH!

Hey Dermot,

Thanks for that. My brain wasn't quite engaged, but as soon as you posted it went "Of course!"

PS. It's been awhile since I've done any database work.

Dean

[deandog]

Oops, sorry about the double post.

*POOF* it's gone!