Hi Shooby, You could look up the external table using an ODBC connection that only resides on the server. Then to lookup the external table call an agent from your Notes document when any event happens. i.e. When the user exits the field the Change Event will run or when they Save the document the Save event will run. This agent that you run set it to RunOnserver. So the code in your will look like this 'Code Dim session As New NotesSession Dim db As NotesDatabase Dim theAgent As NotesAgent Set db = session.CurrentDatabase Set theAgent = db.GetAgent( "YOUR_AGENT_NAME" ) flag = theAgent.RunOnServer If flag <> 0 Then ' Print theagent.Name & " encountered a issue and didn't run as expected." Else Print theagent.Name & " ran as expected." End If 'end of this code In the agent lookup the table via ODBC To get the value returned from the ODBC table you can do this various ways 1) Set an Enviroment Variable from the Agent with the return value 2) Set a global variable in your Notes Doc, assign a value to that var in the agent 3) Set a hidden field on you Notes doc. Let me know if you need anymore help. If this doesn't satisfy your MGT you could use JAVA to create a JDBC connection on the fly. You'd have to do an install on the server though. So the above code you might have to do a server install. MGT are very wary of these installs but I have done then countless times and they are perfectly safe.

Hi Shooby, You could look up the external table using an ODBC connection that only resides on the server. Then to lookup the external table call an agent from your Notes document when any event happens. i.e. When the user exits the field the Change Event will run or when they Save the document the Save event will run. This agent that you run set it to RunOnserver. So the code in your will look like this 'Code Dim session As New NotesSession Dim db As NotesDatabase Dim theAgent As NotesAgent Set db = session.CurrentDatabase Set theAgent = db.GetAgent( "YOUR_AGENT_NAME" ) flag = theAgent.RunOnServer If flag <> 0 Then ' Print theagent.Name & " encountered a issue and didn't run as expected." Else Print theagent.Name & " ran as expected." End If 'end of this code In the agent lookup the table via ODBC To get the value returned from the ODBC table you can do this various ways 1) Set an Enviroment Variable from the Agent with the return value 2) Set a global variable in your Notes Doc, assign a value to that var in the agent 3) Set a hidden field on you Notes doc. Let me know if you need anymore help. If this doesn't satisfy your MGT you could use JAVA to create a JDBC connection on the fly. You'd have to do an install on the server though. So the above code you might have to do a server install. MGT are very wary of these installs but I have done then countless times and they are perfectly safe.