I Have A Database Question

[Leeper]

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

[parksie]

If you have two tables, then:

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.

[Leeper]

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?

[parksie]

*** '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.

[Leeper]

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?

[parksie]

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.

[Leeper]

Much Appreciated now one more question which is better

ADO or DAO?

[parksie]

I prefer DAO, since it seems much more intuitive, with Databases, Recordsets, and the like.

[Leeper]

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

[parksie]

Just substitute the name of the table when opening the recordset.