I have 2 tables with below mentioned fields
TABLE 1
Hub code
Hub name
TABLE 2
Hub code
Hub name
my requirement is, when ever user make any changes to HUB Name in TABLE 1 and click on SAVE button then it should check for Respective HUB Code in TABLE2, if that HUB code is available in TABLE 2 then Error message should trigger Like "Entry already available in TABLE2" and it should go to initial screen. Can anybody suggest me which TMG Event suits for this Requirement with sample code.