I have a Personal Geodatabase to which editors enter values from some field inputs.
I would like some of the entries, eg Project No ( whose name is unique and has some some related attributes like contractor etc ) to be checked against an MySQL database and pop up properties of that Project number from External DB to be available for comparison during data entry..
Reason : This would help to avoid wrong Project name entry , double check whether its the Same project which is currently being entered, based on related properties.
Note : I had a conversation with the Developer of the External Web application from where we want to fetch the data - Its a PHP application having a MySQL database at backend. So basically I would need to have a secure Loging from the ArcGIS editing Window/Session.Does this warrant a different approach ?