In one of my application, I have to update the table B automatically when a new entry has been added,modified or deleted from the table A. The table A has two fields 'ID' and 'Name'. The table B also has the same two fields. Unfortunately this database was designed by someone else, and there are lot of redundent tables.
How can I achieve this. Any clue or help is greatly appreciated.
Sorry for Brent but his code will only work if you enter a new value. It will not update any existing values.
The problem is solvable but will requuire quite some coding. The best solution for you is to remodel the database and get rid of that redundent data!
Don't try to solve it otherwise, you'll just get further into the sh....