Getting an update query to run automatically

[anthony.carter]

Hi,

I wish to get an update query to run automatically (and first) when
other queries are run.

In the database are queries which are dependant on a table (Table A).
This table contains information from another table (Table B) which
changes daily. A query has been created to update my table (Table A)
from the original (changing) table (Table B). Other queries have been
created which play around with the information from my table(Table A).
So in order for these other queries to be up to date there is a need
for the update query to be run first and, hopefully, automatically.

Where on earth do I start?

Cheers,

TC

 

[Brian]

Well depends on what you mean by automatically.. If you mean when
someone goes to open the database then just make a macro and call it
AutoExec... then have in the autoexec a runcode and create a seperate
module that calls the query in whatever order you want