Dear All,
I have designed one table… In that i am having three fields,
CustAccount, Cheque No, Cheque Amount…
In customer master table i am having an enum value.
Now if the custAccount matches in both the tables means (The table which is designed by me and CustTable)
that enum value should change its status as ‘blocked’
How to do this… Please do the needful asap.
Regards,
Madhan
One option is to make CustAccount in your table immutable (so you won’t need to care about table updates) and update the enum in CustTable when a record in your table is created or deleted.
The other (prefered) option is not to create the checkbox at all and calculate the value when needed. Set CustAccount as primary key in your table, set CacheLookup to FoundAndEmpty (if it’s not against other requirements) and implement and use exist() method.