I have a mysql database and I want a Trigger To Update A Field When Field In Another Table Is Changed.
Table 1 = cases_cstm and Table 2 = Contracts
I have an End date field in both tables.
The Field name under cases_cstm is enddate_c
The field name under Contracts is end_date
I would like when a Case is created to copy the End date from Contracts to Cases