Hi everyone, noob here.
I need to link together two databases, one a production system in
Firebird
(read only), and the other a scratchpad in MySQL. I have much of this
running in VBA, but thats of little use to my remote users on their
phones/tabs/etc. It’s time to get with the 21st century anyway.
We have an order tracking system where the order goes through certain
states. When it gets to one of these, we have to enter data into a 3rd
party tracking system, which hands back a tracking number. You might
split
the order across several shipments. I’m finding our sales reps are
finding
it difficult to track what’s going on once it gets to the shipping side.
So what I’d like to do is make a private web page (with logins) what the
user can go to. It would display the list of orders in that shippable
state, and any tracking numbers generated for them. Some of the users
would
be able to edit the tracking numbers as they are generated. This would
be
all manual, the 3rd party system is in MSSQL, but I don’t have access to
it
(yet).
This seems like a suitable first-timer project. But the trick is
linking
two DBs that don’t talk to each other, I assume that I’m going to have
to
loop over the results of the first query and do sub-queries to look up
info
in the scratchpad?
Can someone point me to an example using multiple DB’s that I might
bootstrap off of? All the examples I’ve seen are based solely on MySQL.
There’s a few hits in Google, but nothing for the noob.