Updating several tables in Access 2007 with one query
Here's one for you....
I have an query in Access 2007 which takes data from a form and adds it to a stock table. This works fine and dandy.
What I'm searching for (currently Googling) is a way of sending that new data to 6 other tables (individual shops). Each of the 6 tables has a different name e.g. tblStockBristol, tblStockCardiff etc
Basically in this database when you purchase a new item for the warehouse, the stock list for each individual shop needs to be updated as well.
Got me searching for a while now so maybe someone can think quicker.