-
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
-
If you have two tables, then:
Code:
SELECT Table1.Name, Table2.OtherInfo FROM Table1, Table2 WHERE Table1.ID = 1 AND Table2.ID = 1
This worked on MySQL, anyway, so it should work on Access. I'm not sure about the SQL92 compatibility issues here.
-
RE Database question
Ok I Understand that but i do have a question does that work for the multiple databases? I mean I should say i think i know what you are saying i just dont understand if that is for the report or for accessing the differant tables?
-
*** 'scuse me while I bash my head on the table ***
Sorry. Me much confused. I thought you were more tables in one database. If you link the tables into a new database, it will work.
-
Im Sorry ive confused you:( So all i have to do is create a new database and link the tables is what you are saying?
-
Pretty much. Then as far as Access is concerned all the tables are in one DB and you can do all the normal operations on them.
-
Thank You
Much Appreciated now one more question which is better
ADO or DAO?
-
I prefer DAO, since it seems much more intuitive, with Databases, Recordsets, and the like.
-
ok one last question
Ok Ok I think you have heard enough from me but i did get the databases linked and now when it comes to the coding of the form like if i wanted to switch tables so that it adds the record to the right place i just do an if statement? please inform
-
Just substitute the name of the table when opening the recordset.