Skip to Content
0

Which Table maintenance Generator event suits for below scenario?

Apr 19, 2017 at 09:35 AM

95

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

jyothir aditya k Apr 19, 2017 at 09:40 AM
-1

Hi Kiran,

You can use 05-create a new entry or 21-fill hidden fields.

Reward if helpful.

Regards,

Aditya

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Aditya,

Thanks for your Reply.

But here the case is Record is exists in both the tables. when HUB Name is changed and click on SAVE button then Error message should trigger if entry exist in TABLE2.

Can i choose EVENT 01(Before saving the data in the database)

0