I have a complex question at least to me.....

I am working on a major program for the company i work for in my spare time and have run out of fields to use in the database itself. What i would like to do is this.

1. Seperate the Databases (Which i have done) and I have relationships to each table. I would like to know how can I use all the tables at once, like if someone was to click option 1 or whatever it saves it to that database etc.

2. When it comes to printing reports i would like to have it search all the tables for the qualifications. How can I Do This?

Anyhow that is my main question i am using DAO But I think ADO would work better if you have any suggestions please let me know cause i am quite stumped here for the time being with the above problems/Opportunities

Thanks