Hi all,
I am in a situation currently where I have to wright a new report that involves 3 databases. I made a select query and I am trying to import the query to the new database where I will be adding more information to that query. I would like to know though what is the most up to date way to do this. I want to eventually every time someone clicks a button on a form that the query runs and selects the most up to date information. Do I need to instead of importing to link the tables by making my select query its own table but that still makes me nervous because how do I know that data from my linked table is up to date? Is there a way to make sure the data in the other database is always up to date?
Thanks,
Nick