Linking to specific database based on formula

[GLmill]

What I've got is a database that has hundreds of tables. These tables are created and named automatically inside the original database. I need to be able to link to them based on either a formula or a parameter field. Here is an example of what I need. I have a database called Jobrpt.mdb, inside this database is a table called jobs along with numerous other tables. I need to be able to report on the other table/tables based on a field or formula from the jobs table. Is this possible?

 

[lbass]

It sounds like you're only working with one database, which you would connect to for your report. Then you would just add the tables that contain the fields you want to report on, and link them using a unique field that they have in common. You can then use a select statement that limits records to those which have a certain value in the jobs table, e.g., {jobs.field} = 123, and then report using the desired fields from other tables.

If your question is more complex than this, you need to provide additional information. It is unclear why you need to "link to them with a formula or a parameter field." If you need help setting up a parameter, I or someone would be glad to help.

-LB

 

[GLmill]

The problem is the tables are created daily. What I need to be able to do is reference a table that has not yet been created when the original report was written. I need to be able to write the report using standard data, however, at run time have it get records from a table that I can not add to the report. Basically I need to be able to have a formula or parameter to open the database and extract that day's records. I can not control the new tables being written daily.