Mason,
From your description it sounds like you need to reference an external DB maintained by a system other than Cloverleaf(R).
In order to do that I think you will need to utilize Tcl and either ODBC or JDBC.
On the other hand if you were thinking of using the built in lookup table, then some things to consider:
How will the Table get updated (I think you said every minute)? There is only the GUI Table configurator tool provided by Cloverleaf(R)and that requires a human at the other end. How will you control access and if you expect to maintain the table yourself (or another integration engineer) and the table is fairly dynamic – will you have the time?
You need to refresh the Table in memory for Cloverleaf(R) to get the latest copy (purge caches will do the trick).
As far as I know the Table has to reside on the Cloverleaf(R) server.
Jim Kosloskey
email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 61 years IT – old fart.