I need it to do add an event to my database so that when a record is addded to table A, it automatically runs query B (Make table query) to update my totals in table C.
I currently use this database an ASP driven website.
Thanks,
Anthony
I need it to do add an event to my database so that when a record is addded to table A, it automatically runs query B (Make table query) to update my totals in table C.
I currently use this database an ASP driven website.
Thanks,
Anthony
I'm getting a bit confused.
You want to run B a MAKE TABLE query to UPDATE table C?
A make table query doesn't update anything, it creates a new table
So are you trying to MAKE a temporary table of some sort or are you trying to run an UPDATE QUERY?
Also, why do you want to maintain a summary table when you could create a query that does any sort of summarizing you want? You could then reference the summary query. This would prevent you from having to store and update data permanently (leaving yourself open to errors).