Re: Query In Access 2007
I've never been a big fan of access so i'm not sure on the exact way of doing this. But what you need to look into is Databse triggers and stored procedure.
What you will be doing here is creating a stored procedure which is in affect a stored query which is triggered upon update of your first table.
He who has never failed has never attempted anything worth succeeding at.
Dont Eat Animals, Its Not Good For Them And They Dont Like It!