No there is nothing difficult about what you want to do from what I have read, Im not an SQL guru but have many years experience with it and the first point of advise I would give you is to put all the tables in one database, that is the very purpose of a database. to try to do what you are saying in three databases is ridiculas, especially for a person new to SQL because you have to join databases as well as tables.
There are many alternatives to putting in one DB but all would be the wrong thing to do in such a situation.
quote:I know I could have used 1 DB w/3 tabls but Im not going back now LOL
TRUST ME, go back now.
If this site is going to last you any period of time and you continue to use it you will face lots of problem every time you try to enhance you app.
If you are prepared to do this you will find that you will get a lot of help from this forum. But please be aware that this is an SQL forum and details such as joining databases in Access may be too product specific to get any real answer, hence put you tables in one database and we can help.
If any gurus dissagree with me, please comment and help Mitch out.
They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad.