I have a website that does two things:
1) It allows users to select a group from the drop-down menu and click a button to run a report in a group that already exists in our database.
2) If the group is not yet in the list of groups, the second page allows the user to enter some information about the group into our database (with the idea that they can then run a report for this group.
When the website creator created the website, he placed the drop-down menus in one database and collected the group information collected in another.
Problem: After collecting new information about the group, I need to update the drop-down table in another database to include the name of the new group.
The simplest fix would probably be to update the site with both tables, but we no longer have the services of the guy who encoded the website, and I need to fix it. So I want to fix this on the database side.
I thought I could do this with the insert trigger, however the other lines indicate that the interbase database triggers are not kosher.
To further complicate the matter, our databases are hosted on Microsoft Azure. I found a message on how to make a choice of two operators in Azure, and I'm trying to work with it to create a cross-database right now. I'm still not sure how to solve the problem of the need for data in both databases.
What can I do?
source
share