Maybe the title is kinda cryptic ....
But, what I want to do is this:
I am saving a record into table1. Based on this, I will need to save some values into table2. On inserting another record within table1, I want to update and edit (actually modify) the mentioned record in table2.
How do I do this. I am confusing myself into a corner here. Please help?