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..
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.
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 Login from the ArcGIS editing Window/Session.
Does this warrant a different approach?