Intresting

Question

We have a web application [say for example WebA], which our firm uses to enter the transaction of our customers.
We also make use another web application [say for example WebB], owned by another firm, using the login provided by them to do some transactions . At end of the transaction(save the transaction), we manually input the transactions that we made in this[WebB] application back to our web application[WebA]
Now we want to automate this process.
So my questions are
  How to capture the data of "WebB" inside our web application "WebA"

Answer 1

well you can look at this problem in this way you have a Database for WebA say DBa and database for WebB say DBb now when you insert a record in DBb in a table say t1 you can use an insert after trigger to insert the record in DBa table t1 for example. this will solve the problem May b.. isn't it intresting solution.