Members may post updates or alternatives to this current article in order to show different
approaches or add new features.
If I have got you correctly, you need to update a value in another table when a value is added to a table.1. Write sql to update the value to another table just after adding to 1st table (use transaction)2. Use Trigger, if you are using RDBMS databasecheers